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.