Skip to content

Temporal and interval literals

RETURN DATE '2026-06-29' AS day, TIME '12:30:00' AS time, DATETIME '2026-06-29T12:30:00' AS instant, DURATION 'P1D' AS duration, INTERVAL '1 02:03:04' DAY(2) TO SECOND(6) AS interval;

TIMESTAMP is also recognized. SQL interval qualifiers include single fields and ranges such as DAY TO SECOND with precisions. There is no general temporal query execution or timezone conversion implied by this syntax.

See supported features for executable alternatives.