2. SQL Data Types
 
Share this page                  
SQL Data Types
Data Types
The following data types are supported:
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.
 
TIIMESTAMP 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
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
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'