Data Types

Input and Output Types

CeloSQL supports the following input / output data types. All types are nullable.

Data Type	Description
BIGINT	Represents 8-byte signed integer numbers
BOOLEAN	Represents boolean values: TRUE, FALSE, NULL
DATE	Represents year, month, day, without time zone, e.g. 2025-01-01
DECIMAL(p, s)	Represents numbers with maximum precision `p` and fixed scale `s`
DOUBLE	Represents 8-byte double-precision floating point numbers
TIMESTAMP	Represents year, month, day, hour, minute, second, up to 6-digit fractional second, without time zone, e.g. `2025-01-01 12:00:00.123456`
TIMESTAMP WITH TIME ZONE	Represents year, month, day, hour, minute, second, up to 6-digit fractional second, and time zone, e.g. `2025-01-01 12:00:00.123456 UTC`
VARBINARY	Represents a variable length byte sequence values
VARCHAR	Represents variable length character strings
INTERVAL [X TO Y]	Represents a time interval measured in units X to Y.
TIME	Represents a time of day without timezone
BINARY^*	Represents byte sequence values
CHAR^*	Represents fixed length character strings
TIME WITH TIME ZONE⁺	Represents A time of day with a timezone

+: these types are marked as deprecated and support will be removed.

*: These types are marked as deprecated for input / output types, but still supported as In-SQL types.

CeloSQL supports the following types within SQL statements, but not as input or output types.

Data Type	Description
INTEGER	Represents a 4-byte signed integer numbers