Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
GLS User's GuideThese topics describe the Global Language Support (GLS) feature available in HCL® OneDB® products.The HCL OneDB™ GLS User's Guide describes the Global Language Support (GLS) feature available in HCL® OneDB® products.
featuresThese topics explain how the GLS feature affects , an SQL application programming interface (API).
Enhanced ESQL/C library functionsHCL OneDB™ SQL API products support locale-specific enhancements to the library functions.
DATE-format functionsThere are several DATE-format functions that support extensions to format era-based DATE values.
Precedence for date display formatsThe DATE-format functions use a precedence to determine the display format for values in DATE columns:

Precedence for date display formats

The DATE-format functions use a precedence to determine the display format for values in DATE columns:

The precedence is as follows:

The display format that DBDATE specifies (if DBDATE is set)
The display format that GL_DATE specifies (if GL_DATE is set)
The display date format that the client locale specifies (if CLIENT_LOCALE is set)
The display date format from the default locale: %m %d %iY

Tip: HCL OneDB™ products support DBDATE for compatibility with earlier products. It is recommended that you use the GL_DATE environment variable for new client applications.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.