(11-07-21)DATA TYPES IN BRIEF

 

DATA TYPES IN SQL:

1) NUMERIC  

2) DATE AND TIME

3)STRING TYPES

NUMERIC:

#INT :  NORMAL SIZED INTEGER WHICH CAN BE SIGNED OR UNSIGNED.                                                 SPECIFY WIDTH UPTO 11 DIGITS.

#FLOAT : A FLOATING POINT NUMBER THAT CANNOT BE UNSIGNED.                                                       BY DEFAULT IT IS 10,2 THAT IS 2 IS THE NUMBER OF DECIMALS AND 10 IS                             THE TOTAL NUMBER OF DIGITS(INCLUDING DECIMALS).                                                            DECIMAL PRECISION CAN GO TO 24 PLACES FOR A FLOAT.

DATE AND TIME:

#DATE : A DATE IN YYYY-MM-DD FORMAT.

#DATETIME : A DATE AND TIME COMBINATION IN YYYY-MM-DD   HH:MM:SS.

#TIME : TIME IN  HH:MM:SS.

STRING:

#CHAR : FIXED LENGTH STRING BETWEEN   1 AND 255    CHARACTERS.

#VARCHAR : VARIABLE LENGTH STRING BETWEEN   1 AND 255    CHARACTERS.