Sunday, 30 March 2014

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.

No comments:

Post a Comment

Others

You will like to read it