DATETIME

​

Syntax

​

Scalar

datetime(value [, timezone])

​

Arguments

​

Returns

• Type: TIMESTAMP with the specified constant time zone; UTC by default
• NULL behavior: NULL timestamp yields NULL. NULL or invalid timezone raises an error.

​

Properties

​

Usage notes

• DATETIME takes a TIMESTAMP and an optional STRING time zone.
• Use the argument combinations in Syntax. Separate date/time components and numeric epoch overloads are outside these forms.

​

Examples

​

Basic example

SELECT datetime(TIMESTAMP '2024-01-01 00:00:00','UTC') AS result;

​

Keep a timestamp in UTC

SELECT datetime(TIMESTAMP '2024-02-29 12:30:00', 'UTC') AS leap_day;

​

Limitations

• A constant time-zone argument sets the result’s time zone. For example, UTC produces a TIMESTAMP with microsecond precision and the UTC time zone.