Data Type 
Syntax 
Explanation 
integer 
integer 

smallint 
smallint 

numeric 
numeric(p,s) 
Where p is a precision value; s is a scale value. For example, numeric(6,2) is a number that has 4 digits before the decimal and 2 digits after the decimal. 
decimal 
decimal(p,s) 
Where p is a precision value; s is a scale value. 
real 
real 
Singleprecision floating point number 
double precision 
double precision 
Doubleprecision floating point number 
float 
float(p) 
Where p is a precision value. 
character 
char(x) 
Where x is the number of characters to store. This data type is space padded to fill the number of characters specified. 
character varying 
varchar2(x) 
Where x is the number of characters to store. This data type does NOT space pad. 
bit 
bit(x) 
Where x is the number of bits to store. 
bit varying 
bit varying(x) 
Where x is the number of bits to store. The length can vary up to x. 
date 
date 
Stores year, month, and day values. 
time 
time 
Stores the hour, minute, and second values. 
timestamp 
timestamp 
Stores year, month, day, hour, minute, and second values. 
time with time zone 
time with time zone 
Exactly the same as time, but also stores an offset from UTC of the time specified. 
timestamp with time zone 
timestamp with time zone 
Exactly the same as timestamp, but also stores an offset from UTC of the time specified. 
yearmonth interval 

Contains a year value, a month value, or both. 
daytime interval 

Contains a day value, an hour value, a minute value, and/or a second value. 