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.
DATETIME-format functionsThe DATETIME-format functions are dtcvfmtasc( ) and dttofmtasc( ).
DBTIME supportThe DATETIME-format functions support the extended era-based date and time format strings for the DBTIME environment variable.

DBTIME support

The DATETIME-format functions support the extended era-based date and time format strings for the DBTIME environment variable.

When you set DBTIME to an era-based format, these functions can convert between literal DATETIME strings and internal DATETIME values.

Tip: HCL® OneDB® products support DBTIME for compatibility with earlier products. It is recommended that you use the GL_DATETIME environment variable for new applications.

If you set DBTIME to an era-based DATETIME format (which is specific to a Chinese or Japanese locale), make sure to set the CLIENT_LOCALE environment variable to a locale that supports era-based dates and times.