TIME

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

---

[{[ dimension ] | ( dimension )}] TIME(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 TIME columns

A TIME column can contain times that lie within 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.

Example

You define a TIME column wakeup_time as follows:

wakeup_time TIME(3)