Overview of Exasol data types

Data type Description

BOOLEAN

See Boolean data type

DECIMAL(p,s)

See Numeric data types

DOUBLE PRECISION

DATE

See Date and time data types

TIMESTAMP(p)

TIMESTAMP(p) WITH LOCAL TIME ZONE

INTERVAL DAY(lfp) TO SECOND(fsp)

See Interval data types

INTERVAL YEAR(p) TO MONTH

GEOMETRY(srid)

See Geospatial data type

HASHTYPE(n BYTE)

or

HASHTYPE(m BIT)

See HASHTYPE data type

CHAR(n)

See String data types

VARCHAR(n)