Data Types

This section describes the data types and aliases supported by Exasol.

In addition to the standard SQL data types, additional data types are implemented in Exasol to ensure compatibility with other databases. To determine the data type for a specified expression, you can use the TYPEOF function.

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)

For more details about data types in Exasol, see the following pages: