Date and time precedence
HCL OneDB™ products use a precedence to determine the display format for an internal DATE value.
HCL
OneDB products
use the following precedence:
- DBDATE (deprecated)
- GL_DATE
- Information defined in the client locale (if CLIENT_LOCALE is set)
- Default date format is
%m/%d/%iy
(if DBDATE and GL_DATE are not set, and no locale is specified)
HCL
OneDB products
use the following precedence to determine the display format for an
internal DATETIME value:
- DBDATE (deprecated) and DBTIME (deprecated)
- GL_DATETIME
- Information that the client locale defines (CLIENT_LOCALE, if it is set)
- Default DATETIME format is
%iY-%m-%d %H:%M:%S
(if CLIENT_LOCALE, DBTIME and GL_DATETIME are not set)
For more information about these formatting directives, see GL_DATE environment variable and GL_DATETIME environment variable.