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.
HCL OneDB™ ESQL/C featuresThese topics explain how the GLS feature affects HCL OneDB™ ESQL/C, an SQL application programming interface (API).
Enhanced ESQL/C library functionsHCL OneDB™ SQL API products support locale-specific enhancements to the HCL OneDB™ ESQL/C library functions.
DATE-format functionsThere are several HCL OneDB™ ESQL/C DATE-format functions that support extensions to format era-based DATE values.
Precedence for date display formatsThe HCL OneDB™ ESQL/C DATE-format functions use a precedence to determine the display format for values in DATE columns:

Precedence for date display formats

The HCL OneDB™ ESQL/C 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.