Data Types in SQL

Data Types :


Datetime Data Types :

• The TIMESTAMP data type is an extension of the DATE data type.
• It stores the year, month, and day of the DATE data type plus hour, minute, and second values as well as the fractional second value.
• You can optionally specify the time zone.

• TIMESTAMP[(fractional_seconds_precision)]
• TIMESTAMP[(fractional_seconds_precision)] WITH TIME ZONE