Date and Time Datatypes

DATE：The DATE datatype stores century, year, month, date, hour, minute, and seconds internally

TIMESTAMP：The TIMESTAMP datatype stores date and time information with fractional

seconds precision。The default precision is 6 and can range from 0 to 9.

TIMESTAMP WITH TIME ZONE：The TIMESTAMP WITH TIME ZONE datatype is similar to the TIMESTAMP datatype, but it stores the time zone displacement.

TIMESTAMP WITH LOCAL TIME ZONE：

TIMESTAMP WITHLOCAL TIME ZONE does not store the displacement information in thedatabase, but stores the time as a normalized form of the database time zone.The data is always stored in the database time zone, but when the userretrieves data, it is shown in the user’s local session time zone.

INTERVAL YEAR TO MONTH：

Specification INTERVAL YEAR [(precision)] TO MONTH

The INTERVAL YEAR TO MONTH datatype is used to represent a period of time as years and months. The precision specifies the precision needed for the year field, and its default is 2.

INTERVAL DAY TO SECOND：

Specification INTERVAL DAY [(precision)] TO SECOND

The INTERVAL DAY TO SECOND datatype is used to represent a period of time as days, hours, minutes, and seconds. The precision specifies the precision needed for the day field, and its default is 6. Valid precision values are from 0 to 9.