Dates, times, and timestamps for edit and validation routines
The values in columns with data types of DATE, TIME, and TIMESTAMP are stored in specific formats.
The DATE format that consists of 4 total bytes
:
Year | Month | Day |
---|---|---|
2 bytes | 1 byte | 1 byte |
The TIME format, which consists of 3 total bytes:
Hours | Minutes | Seconds |
---|---|---|
1 byte | 1 byte | 1 byte |
The following table shows
the TIMESTAMP format, which consists of 7 to 13 total bytes.
Year | Month | Day | Hours | Minutes | Seconds | Partial second
|
---|---|---|---|---|---|---|
2 bytes | 1 byte | 1 byte | 1 byte | 1 byte | 1 byte | 0 to 6 bytes
|