Product Documentation

Appearance

MAKE_TIMESTAMP ​

Make a complete TIMESTAMP value from a series of datetime values.

MAKE_TIMESTAMP(year, month, day, hour, minute, seconds)
  • The year, month, day, hour, and minute values are integers.
  • The seconds value is a double precision number.

For example:

premdb=# UPDATE match 
SET matchday=MAKE_TIMESTAMP(2011,8,20,15,00,00) 
WHERE matchday='2011-08-20';
UPDATE 6

premdb=# select * from match where matchday='2011-08-20 15:00:00';
 seasonid |      matchday       | htid | atid | ftscore | htscore 
----------+---------------------+------+------+---------+---------
      20 | 2011-08-20 15:00:00 |    2 |   73 | 0-2     | 0-0
      20 | 2011-08-20 15:00:00 |    3 |   55 | 3-1     | 2-0
      20 | 2011-08-20 15:00:00 |   14 |   93 | 2-1     | 0-1
      20 | 2011-08-20 15:00:00 |   18 |   82 | 0-1     | 0-1
      20 | 2011-08-20 15:00:00 |   39 |   77 | 0-1     | 0-0
      20 | 2011-08-20 15:00:00 |   40 |   95 | 0-0     | 0-0
(6 rows)

Parent topic:Datetime Functions