Date-time data types are used to define points in time.

Syntax

This is the syntax for the date-time data types:

DATE | TIME | TIMESTAMP | TIMESTAMP WITH TIME ZONE

Parameters

DATE

Stores a date value as three parts: year, month, and day. The ranges for the parts are:

• Year: 1 to 9999
• Month: 1 to 12
• Day: Lower limit is 1; the upper limit depends on the month and the year

TIME

Stores a time value as four parts: hours, minutes, seconds, and milliseconds. The ranges for the parts are:

• Hours: 0 to 23
• Minutes: 0 to 59
• Seconds: 0 to 59
• Milliseconds: 0 to 999

TIMESTAMP

Combines the parts of DATE and TIME

TIMESTAMP WITH TIME ZONE

Combines the elements of TIMESTAMP with a time zone offset