Time Functions

This section describes functions and operators for examining and manipulating TIME values.

Time Operators

The table below shows the available mathematical operators for TIME types.

Operator	Description	Example	Result
`+`	addition of an `INTERVAL`	`TIME '01:02:03' + INTERVAL 5 HOUR`	`06:02:03`
`-`	subtraction of an `INTERVAL`	`TIME '06:02:03' - INTERVAL 5 HOUR`	`01:02:03`

The table below shows the available scalar functions for TIME types.

Name	Description
`date_diff(part, starttime, endtime)`	The number of `part` boundaries between `starttime` and `endtime`, inclusive of the larger time and exclusive of the smaller time.
`date_part(part, time)`	Get subfield (equivalent to `extract`).
`date_sub(part, starttime, endtime)`	The signed length of the interval between `starttime` and `endtime`, truncated to whole multiples of `part`.
`extract(part FROM time)`	Get subfield from a time.
`get_current_time()`	Current time (start of current transaction).
`make_time(bigint, bigint, double)`	The time for the given parts.

The only date parts that are defined for times are epoch, hours, minutes, seconds, milliseconds and microseconds.

The number of part boundaries between starttime and endtime, inclusive of the larger time and exclusive of the smaller time. Alias: datediff.

SQL

SELECT date_diff('hour', TIME '01:02:03', TIME '06:01:03') AS date_diff;

 date_diff
-----------
         5

Get subfield (equivalent to extract). Alias: datepart.

SQL

SELECT date_part('minute', TIME '14:21:13') AS date_part;

 date_part
-----------
        21

The signed length of the interval between starttime and endtime, truncated to whole multiples of part. Alias: datesub.

SQL

SELECT date_sub('hour', TIME '01:02:03', TIME '06:01:03') AS date_sub;

 date_sub
----------
        4

Get subfield from a time.

SQL

SELECT extract('hour' FROM TIME '14:21:13') AS extract;

 extract
---------
      14

Description	Current time (start of current transaction) in the local time zone as `TIMETZ`.
Example	`get_current_time()`
Result	`06:09:59.988+2`
Alias	`current_time` (no parentheses necessary)

The time for the given parts.

SQL

SELECT make_time(13, 34, 27.123456) AS make_time;

 make_time
-----------------
 13:34:27.123456