Date/time types

As a rule, EGL separates date information from presentation format.

Table 1. Primitive date/time types
Primitive Size Data format
DATE 8 digits Gregorian yyyyMMdd
INTERVAL 1 to 21 digits Based on mask
TIME 6 digits HHmmss
TIMESTAMP 1 to 20 digits Based on mask
The following considerations apply to date/time types:

Compatibility

Table 2. Compatibility considerations for date/time types
Platform Issue
iSeries® COBOL If a DATE type variable corresponds to an SQL column that is defined as DATE in the SQL database, the date format of the data in the database must match the format specified by the iSeries QDATFMT system variable.
JavaScript generation Rich UI does not support the Interval type. For other details, see “Rich UI date and time support.”
z/OS® COBOL If a DATE type variable corresponds to an SQL column that is defined as DATE in the SQL database, the date format of the data in the database must match the format specified by the Default Long System Gregorian Date Format for the national language options module.

Feedback