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. |