The operations that set the DATE format are best described as a hierarchy, where one setting overrides another.
At the lowest level, the system comes with a DateForm of IntegerDate ('YYYY/MM/DD'). Your system administrator can override that date format by creating a custom SDF that changes the default DATE format (any valid date format).
You can override the system-level date format for a user, session, individual column, or individual value.
The following table summarizes the hierarchy of date formats.
| Operation | Format Location | Session Date Setting | Field Mode Display Format |
Export Data Type |
|---|---|---|---|---|
| SELECT with FORMAT phrase | an individual column | user-defined display format | as defined by FORMAT | CHAR(10) if DateForm is ANSIDate; ELSE 8-byte integer |
| CREATE / ALTER TABLE, with FORMAT phrase | ||||
| SET SESSION DateForm | the session | ANSIDate | YYYY-MM-DD | CHAR(10) |
| CLI SessionOptions parcel DateForm | IntegerDate | YYYY/MM/DD, or the value of the DATE element in a custom SDF | 8-byte integer | |
| CREATE / MODIFY USER DateForm | the user | ANSIDate | YYYY-MM-DD | CHAR(10) |
| IntegerDate | YYYY/MM/DD, or the value of the DATE element in a custom SDF | 8-byte integer | ||
| System DBS Control utility DateForm |
the system | ANSIDate | YYYY-MM-DD | CHAR(10) |
| IntegerDate | YYYY/MM/DD, or the value of the DATE element in a custom SDF | 8-byte integer | ||
| Default DATE format in custom SDF | the system | IntegerDate | as defined by the DATE format in the SDF | 8-byte integer |