SQL: DATA TYPES

Datatype using in SQL syntax;

Type	Syntax	description
integer	integer	contaning the number values
bit	bit(x)	x is  number of bits to store.
bit varying	bit varying(x)	x is  number of bits to store. The length can vary based on x.
character	char(x)	x is  number of characters to store.
character varying	varchar2(x)	x is the number of characters to store. This data type does NOT space pad.
date	date	Stores year, month, and day values.
day-time interval		Contains a day value, an hour value, a minute value, and/or a second value.
decimal	decimal(p,s)	p is a precision value; s is a scale value.
double precision	double precision	Double-precision floating point number
float	float(p)	p is a precision value.
numeric	numeric(p,s)	p is a precision value; s is a scale value. For example, numeric(7,2) is a number that has 5 digits before the decimal and 2 digits after the decimal.
real	real	Single-precision floating point number
smallint	smallint	small interger values
time	time	Stores the 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	timestamp	Stores year, month, day, hour, minute, and second values.
timestamp with time zone	timestamp with time zone	Exactly the same as timestamp, but also stores an offset from UTC of the time specified.
year-month interval		Contains a year value, a month value, or both.