Skip to main content

System Data Types

Built in data types

  • System data types are the data types used for columns, conversion, and arithmetic.
Data typeDescriptionCategory
BYTEARRAYA slice of bytes.Raw
STRINGA string type represents the set of string values whose default length is 255 bytes unless specified.Literal
UINT8Unsigned 8-bit integers (0 to 254).Numeric
INT8Signed 8-bit integers (-127 to 127).Numeric
UINT16Unsigned 16-bit integers (0 to 65534).Numeric
INT16Signed 16-bit integers (-32767 to 32767).Numeric
UINT32Unsigned 32-bit integers (0 to 4294967294).Numeric
INT32Signed 32-bit integers (-2147483647 to 2147483647).Numeric
UINT64Unsigned 64-bit integers (0 to 18446744073709551614).Numeric
INT64Signed 64-bit integers (-9223372036854775806 to 9223372036854775806).Numeric
FLOAT32IEEE-754 32-bit floating-point numbers (max reserved for NULL representation).Numeric
FLOAT64IEEE-754 64-bit floating-point numbers (max reserved for NULL representation).Numeric
BOOLBoolean types that consists of the two predefined constants: (a) true (b) false.Raw
TIMESTAMPA timestamp with nanosecond accuracy stored as an int64. Timestamp is restricted to date times within the range [1677-09-21 00:12:43.145224192 +0000 UTC, 2262-04-11 23:47:16.854775807 +0000 UTC)Date & Time
DATETIMEA timestamp with second accuracy stored as an int64 and can handle date times in the range (0001-01-01 00:00:00 +0000 UTC, 292277026596-12-04 15:30:07 +0000 UTC)Date & Time
DATEA date stored as a UINT16 and two UINT8s (4 bytes) and can handle dates in the range (0001-01-01 00:00:00, 65555-10-12)Date & Time
TIMEA time stored as three UINT8s (3 bytes) and can handle times in the range (00:00:00, 23:59:59)Date & Time
COMPUTEDA generated type that is never stored, only computed on output based on a provided computational expression.NA