Conceptually, TIMESTAMP is treated as a record composed of six fields, defined appropriately for the Gregorian calendar.
| Field Name | Minimum Value | Maximum Value | Storage Format |
|---|---|---|---|
| SECOND | 00.000000 | 61.999999 This value accounts for leap seconds that can be added to the clock. |
INTEGER (DECIMAL(8,6)) |
| YEAR | 0001 | 9999 | SMALLINT |
| MONTH | 01 | 12 | BYTEINT |
| DAY | 01 | 28, 29, 30, or 31 (depending on the month and year) |
BYTEINT |
| HOUR | 00 | 23 | BYTEINT |
| MINUTE | 00 | 59 | BYTEINT |
Although composed of numeric fields, the record is not treated as a numeric value.
The length of the internal stored form is 10 bytes.