Precedence of DATE and DATETIME format specifications

The HCL OneDB™ environment variables whose settings can specify the display and data entry formats for values of DATE data types have the following order of precedence, if different settings are in conflict, or if no format is specified:
  1. DBDATE
  2. GL_DATE
  3. Information defined in the client locale (if CLIENT_LOCALE is set)
  4. Default date format is %m/%d/%iy (if DBDATE and GL_DATE are not set, and no locale is specified)
HCL OneDB environment variables can specify the display and data entry formats for values of DATETIME data types. Their explicit or default settings have the following descending order of precedence (from highest to lowest), if different settings are in conflict, or if no format is specified:
  1. DBDATE and DBTIME
  2. GL_DATETIME
  3. Information defined in the client locale (if CLIENT_LOCALE is set)
  4. Default DATETIME format is %iY-%m-%d %H:%M:%S (if CLIENT_LOCALE, DBTIME and GL_DATETIME are not set).
If GL_DATETIME is set to a nondefault value, you must also set the USE_DTENV environment variable to 1 before you can process localized DATETIME values correctly in the following contexts:
  • dbexport utility
  • dbimport utility
  • LOAD statement of DB-Access
  • UNLOAD statement of DB-Access
  • DML operations on objects defined by the CREATE EXTERNAL TABLE statement.

For details of how you can set these environment variables to define formats for chronological data values, see the HCL OneDB GLS User's Guide and HCL OneDB Guide to SQL: Reference.