MCPSQL supports the SQL standard TIME data type without timezone. All time data types are based on the 24 hour clock.

A TIME data type literal in an SQL statement must be formatted as follows:

TIME 'hh:mm:ss[.xx]'

The .xx part of the preceding format is 100th of a second and is optional but the TIME keyword is required as well as leading zeros. TIME supplied as a bound parameter to an SQL query must be formatted as hh:mm:ss.xx without the TIME keyword and leading zeros as needed. TIME data types returned as the result of a query are formatted the same as the bound parameter format.

TIME data types stored in Enterprise Database Server databases are expected to conform to the COBOL85 INTEGER-OF-TIME function format (100 th of a second since midnight expressed as an integer). TIME stored through an SQL query conforms to the INTEGER-OF-TIME function format.