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.