The following table provides an overview of the defined data types in Exasol.
| Exasol Type (ANSI type) | Note |
|---|---|
| BOOLEAN |
|
| CHAR(n) |
1 ≤ n ≤ 2,000 |
| DATE |
|
| DECIMAL (p,s) |
s ≤ p ≤ 36 p ≥ 1; s ≥ 0 |
| DOUBLE PRECISION |
|
| GEOMETRY[(srid)] |
srid defines the coordinate system. For more information, see EXA_SPATIAL_REF_SYS. |
| INTERVAL DAY [(p)] TO SECOND [(fp)] |
1 ≤ p ≤ 9, 0 ≤ fp ≤ 9, accuracy precise to a millisecond |
| INTERVAL YEAR [(p)] TO MONTH |
1 ≤ p ≤ 9 |
| TIMESTAMP |
Time stamp with accuracy precise to a millisecond |
| TIMESTAMP WITH LOCAL TIME ZONE |
Time stamp which considers the session time zone |
| VARCHAR(n) |
1 ≤ n ≤ 2,000,000 |