⌘+k ctrl+k
1.4 (stable)
Search Shortcut cmd + k | ctrl + k
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

Time Functions

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

Name Description
current_time Current time (start of current transaction) in the local time zone. Note that parentheses should be omitted from the function call.
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) in UTC.
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.

current_time

Description Current time (start of current transaction) in the local time zone. Note that parentheses should be omitted from the function call.
Example current_time
Result 10:31:58.578
Alias get_current_time()

date_diff(part, starttime, endtime)

Description The number of part boundaries between starttime and endtime, inclusive of the larger time and exclusive of the smaller time.
Example date_diff('hour', TIME '01:02:03', TIME '06:01:03')
Result 5
Alias datediff

date_part(part, time)

Description Get subfield (equivalent to extract).
Example date_part('minute', TIME '14:21:13')
Result 21
Alias datepart

date_sub(part, starttime, endtime)

Description The signed length of the interval between starttime and endtime, truncated to whole multiples of part.
Example date_sub('hour', TIME '01:02:03', TIME '06:01:03')
Result 4
Alias datesub

extract(part FROM time)

Description Get subfield from a time.
Example extract('hour' FROM TIME '14:21:13')
Result 14

get_current_time()

Description Current time (start of current transaction) in UTC.
Example get_current_time()
Result 10:31:58.578
Alias current_time

make_time(bigint, bigint, double)

Description The time for the given parts.
Example make_time(13, 34, 27.123456)
Result 13:34:27.123456
© 2025 DuckDB Foundation, Amsterdam NL
Code of Conduct Trademark Use