Of the various data types of the ANSI SQL standard, Exasol currently supports the DATE and TIMESTAMP(3) types. DATE corresponds to a date. In addition to the date, TIMESTAMP(3) contains the time. Additionally, the data type TIMESTAMP(3) 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(3)||01.01.0001 00:00:00.000 to 31.12.9999 23:59:59.999||
The accuracy is limited to milliseconds
|TIMESTAMP(3) 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(3) type; however, this type also considers the time zone. The accuracy is limited to milliseconds.