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:

pageDATE Data Type

pageTIMESTAMP Data Type

pageTIMESTAMP WITH TIME ZONE Data Type

pageTIMESTAMP WITH LOCAL TIME ZONE Data Type

pageINTERVAL DAY TO SECOND Data Type

pageINTERVAL YEAR TO MONTH Data Type

pageDatetime Arithmetic