Date/Time Data Types

Of the various data types of the ANSI SQL standard, Exasol currently supports the DATE and TIMESTAMP types. DATE corresponds to a date. In addition to the date, TIMESTAMP contains the time. Additionally, the data type TIMESTAMP WITH LOCAL TIME ZONE considers the session time zone. For more information, see ALTER SESSION and SESSIONTIMEZONE.

Exasol Type (ANSI type) Range Note
DATE 01.01.0001 to 31.12.9999

 

TIMESTAMP 01.01.0001 00:00:00.000 to 31.12.9999 23:59:59.999

The accuracy is limited to milliseconds

TIMESTAMP WITH LOCAL TIME ZONE 01.01.0001 00:00:00.000 to 31.12.9999 23:59:59.999

The range is similar to the TIMESTAMP type; however, this type also considers the time zone. The accuracy is limited to milliseconds.