Refer to Numeric Literals for details on specifying values to be stored in date-time columns. See Date Format Strings for details on date strings and Time Format Strings for details on using format strings to specify the output format of date-time columns.
Type DATE stores a date value as three parts: year, month, and day. The range for the parts is:
The c-tree date field stores date as an unsigned 4 bytes integer value representing the number of days since 02/28/1700. Hence the first valid date is 03/01/1700.
A check is done to limit the date range lower bound to 03/01/1700 in case of a c-tree Plus date type and 01/01/1900 for the FairCom DB SQL TIMESTAMP type.
Type TIME stores a time value as three parts: hours, minutes, and seconds. The range for the parts is:
Type TIMESTAMP combines the parts of DATE and TIME.