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.
DATETIME-format functionsThe HCL OneDB™ ESQL/C DATETIME-format functions are dtcvfmtasc( ) and dttofmtasc( ).
Precedence for DATETIME display formatsThe HCL OneDB™ ESQL/C DATETIME-format functions use a precedence to determine the display format of values in DATETIME columns.

Precedence for DATETIME display formats

The HCL OneDB™ ESQL/C DATETIME-format functions use a precedence to determine the display format of values in DATETIME columns.

The precedence is as follows:

The display format that DBTIME specifies (if DBTIME is set)
The display format that GL_DATETIME specifies (if GL_DATETIME is set)
The date and time display formats that the client locale specifies (if CLIENT_LOCALE is set)
The date and time display format from the default locale: %iY-%m-%d %H:%M:%S