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.

Begin program-specific programming interface information.
The DATE format that consists of 4 total bytes :
Table 1. DATE format
Year Month Day
2 bytes 1 byte 1 byte
The TIME format, which consists of 3 total bytes:
Table 2. TIME format
Hours Minutes Seconds
1 byte 1 byte 1 byte
The following table shows the TIMESTAMP format, which consists of 7 to 13 total bytes.
Table 3. TIMESTAMP format
Year Month Day Hours Minutes Seconds

Partial second
2 bytes 1 byte 1 byte 1 byte 1 byte 1 byte

0 to 6 bytes
End program-specific programming interface information.