Era-based date and time formats

The GL_DATE and GL_DATETIME environment variables provide support for alternative dates and times such as era-based (Asian) formats. These alternative formats support dates such as the Japanese Imperial-era dates.

Tip: DBDATE and DBTIME can also provide some support for era-based dates.
To specify era-based formats for DATE and DATETIME values, use the E conversion modifier, as follows:
  • For either GL_DATE or GL_DATETIME, E can show in several formatting directives.

    For a list of valid formatting conversions for eras, see Alternative time formats.

  • For DBDATE, E can show in the format specification.