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 TypepageTIMESTAMP Data TypepageTIMESTAMP WITH TIME ZONE Data TypepageTIMESTAMP WITH LOCAL TIME ZONE Data TypepageINTERVAL DAY TO SECOND Data TypepageINTERVAL YEAR TO MONTH Data TypepageDatetime Arithmetic