DATE

You use the data type DATE for columns that can store a date (see section "Time values" ).

---

[{[ dimension ] | ( dimension )}] DATE

---

dimension

Unsigned integer between 1 and 255. The column is a multiple column;
dimension indicates the number of column elements.

Any square brackets shown here in italics are special characters, and must be specified in the statement.

dimension omitted:
The column is an atomic column.

Range of values for DATE columns

A DATE column can contain date specifications lying in the range 0001-01-01 to 9999-12-31. The date specification must observe the rules of the Gregorian calendar even if the date involved is before the introduction of the Gregorian calendar.

Example

The ORDERS table contains three DATE columns: order_date DATE DEFAULT CURRENT_DATE actual DATE target DATE