TIMESTAMP

You use the data type TIMESTAMP for columns that can store a time stamp (see section "Time values").

---

[{[ dimension ] | ( dimension )}] TIMESTAMP(3)

---

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 TIMESTAMP columns

A TIMESTAMP column can contain dates that lie within the range 0001-01-01 to 9999-12-31 and times that lie within in the range 00:00:00.000 to 23:59:61.999.

The range for seconds (00.000 to 61.999) allows you to specify up to two leap seconds. 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

You define a TIMESTAMP column appointment as follows:

appointment TIMESTAMP(3)