Conceptually, TIME is treated as a record composed of three fields.
Field name | Range of Values | Storage Format | ||
---|---|---|---|---|
Minimum | Maximum | |||
HOUR | 00 | 23 | BYTEINT | |
MINUTE | 00 | 59 | BYTEINT | |
SECOND | 00.000000 | 61.999999 This value accounts for leap seconds that can be added to the clock. |
DECIMAL(8,6) |
Although composed of numeric fields, the record is not treated as a numeric value.
The length of the internal stored form is six bytes.