Class | Data Type | Description |
|---|---|---|
Character | CHAR | CHAR(size) Fixed-length character string having maximum length size bytes. |
VARCHAR | VARCHAR(size) Variable-length character string having maximum length size bytes. | |
NCHAR | NCHAR(size) Fixed length Unicode string having maximum length size characters. | |
NVARCHAR | NVARCHAR(size) Variable-length Unicode string having maximum length size characters. | |
Numeric | INTEGER1 | INTEGER1 Exact number that requires one byte. |
INTEGER2 | INTEGER2 Exact number that requires two bytes. | |
INTEGER4 | INTEGER4 Exact number that requires four bytes. | |
INTEGER8 | INTEGER8 Exact number that requires eight bytes. | |
DECIMAL | DECIMAL(p,s) Exact numeric type with precision p and scale s. | |
FLOAT | FLOAT[(n)] FLOAT8[(n)] Approximate number that requires eight bytes with optional minimum required binary precision of n (24 to 53). | |
FLOAT4 | FLOAT4[(n)] Approximate number that requires four bytes with optional minimum required binary precision of n (0 to 23). | |
Date and time | ANSIDATE | ANSIDATE Year, month, day in the format yyyy-mm-dd. |
TIME WITHOUT TIME ZONE | TIME[(n)] Hour, minutes, seconds with n digits of precision in the fractions of seconds. | |
TIME WITH TIME ZONE | TIME[(n)] WITH TIME ZONE Hour, minutes, seconds with n digits of precision in the fractions of seconds, at the specified time zone. | |
TIME WITH LOCAL TIME ZONE | TIME[(n)] WITH LOCAL TIME ZONE Hour, minutes, seconds with n digits of precision in the fractions of seconds, in local time zone. | |
TIMESTAMP WITHOUT TIME ZONE | TIMESTAMP[(n)] Year, month, day, time with n digits of precision in the fractions of seconds. | |
TIMESTAMP WITH TIME ZONE | TIMESTAMP[(n)] WITH TIME ZONE Year, month, day, hour, minutes, seconds with n digits of precision in the fractions of seconds, at the specified time zone. | |
TIMESTAMP WITH LOCAL TIMEZONE | TIMESTAMP[(n)] WITH LOCAL TIME ZONE Year, month, day, hour, minutes, seconds with n digits of precision in the fractions of seconds, in local time zone. | |
INTERVAL YEAR TO MONTH | INTERVAL YEAR TO MONTH An interval of years and months. | |
INTERVAL DAY TO SECOND | INTERVAL DAY TO SECOND[(n)] An interval of days and seconds with n digits of precision in the fractions of seconds. | |
Abstract | MONEY | MONEY Monetary amount in the range -999,999,999,999.99 to 999,999,999,999.99 |
IPV4 | IPV4 An IPv4 host address. 4-byte, network address in dotted-decimal notation (four decimal numbers, each ranging from 0 to 255, separated by dots). For example: 172.16.254.1 | |
IPV6 | IPV6 An IPv6 host address. 16-byte, network address in eight groups of four hexadecimal digits separated by colons. For example: 2001:0db8:85a3:0042:1000:8a2e:0370:7334 | |
UUID | UUID A unique 128-bit integer. | |
Boolean | BOOLEAN | BOOLEAN Literal values TRUE or FALSE, strings 'TRUE' or 'FALSE' |
Binary | BYTE | BYTE(size) Fixed length binary object, with size ranging from 1-32000. |
VARBYTE | VARBYTE(size) Varying length binary object, with size ranging from 1-32000. |