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
Start of changeThe following table shows the TIMESTAMP format, which consists of 7 to 13 total bytes.End of change
Table 3. TIMESTAMP format
Year Month Day Hours Minutes Seconds
Start of changePartial secondEnd of change
2 bytes 1 byte 1 byte 1 byte 1 byte 1 byte
Start of change0 to 6 bytesEnd of change
End program-specific programming interface information.