MCPSQL supports the SQL standard DATE data type. Dates are based on the Gregorian calendar.

In SQL statements, a DATE literal must be formatted as follows:

DATE 'yyyy-mm-dd'

The keyword DATE is required, yyyy is the year, mm is the month of the year, and dd is the day of the month. A DATE returned as a result of a query is formatted as yyyy-mm-dd without the DATE keyword. A DATE supplied as a bound parameter to an SQL query must conform to the same format as the returned DATE format including leading zeros for months or days less than 10.

DATE data types stored in an Enterprise Database Server database are expected to conform to the COBOL85 INTEGER-OF-DATE function format (days since December 31, 1600). DATE stored through an SQL query must conform to the INTEGER-OF-DATE format.