Customize date and time display formats
The GLS locales define display formats for dates and times, which you do not need to change but which you can customize if necessary.
You can customize display formats for DATE and DATETIME values
(for example, 10-27-97 for the date 10/27/97) with the following environment
variables.
Tip: When you set these environment variables,
you do not affect the internal format of the DATE and DATETIME values
within a database.
| Environment variable | Description |
|---|---|
| GL_DATE | Supports extended format strings for international formats in date display formats. |
| GL_DATETIME | Supports extended format strings for international formats in time display formats. |
| DBDATE (Deprecated) | Specifies a display format for a date. (Supported for compatibility with earlier versions.) |
| DBTIME (Deprecated) | Specifies a display format for time for certain embedded-language (ESQL) library functions. (Supported for compatibility with earlier versions.) |
The GL_DATE and GL_DATETIME environment variables support formatting directives so that you can specify a custom display format. A formatting directive has the form %x (where x is one or more conversion characters).