Datetime and Interval Data Types

The datetime data types are DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. Values of datetime data types are sometimes called datetimes. The interval data types are INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND. Values of interval data types are sometimes called intervals. (Oracle SQL Language Reference Datetime and Interval Data Types)

Here are the articles in this section:

DATE Data TypeTIMESTAMP Data TypeTIMESTAMP WITH TIME ZONE Data TypeTIMESTAMP WITH LOCAL TIME ZONE Data TypeINTERVAL DAY TO SECOND Data TypeINTERVAL YEAR TO MONTH Data TypeDatetime Arithmetic