DATE, TIME, and TIMESTAMP Values

A DATE value designates a point in time by the components year (0001 to 9999), month (1 to 12) and day (1 to 28, 29, 30, 31 depending on the month and year).

A TIME value designates a time of day by the components hour (0 to 24), minute (0 to 59) and second (0 to 59).

A TIMESTAMP value designates a point in time represented by a date and time as defined previously including a fractional specification of seconds with a portable precision of tens of milliseconds.

The DATE and TIME types are not time-zone aware . This means that they behave as if the values were stored in string representation. The TIMESTAMP type, however, is time-zone aware . Values of this type are always stored as UTC time-stamps.

Semantics of the Data Types DATE, TIME, and TIMESTAMP