Date and time data types

Exasol supports the DATE and TIMESTAMP data types from the SQL standard. Additionally, the data type TIMESTAMP WITH LOCAL TIME ZONE can be used to handle timestamps in the session time zone. For more information, see ALTER SESSION and SESSIONTIMEZONE.

Data type Range Note

DATE

0001-01-01 to 9999-12-31

 

TIMESTAMP

0001-01-01 00:00:00.000 to 9999-12-31 23:59:59.999

Timestamp without time zone.

The accuracy is limited to milliseconds.

TIMESTAMP WITH LOCAL TIME ZONE

0001-01-01 00:00:00.000 to 9999-12-31 23:59:59.999

Timestamp considering the session time zone. The accuracy is limited to milliseconds.