Convert DATETIME and INTERVAL values

HCL OneDB™ ESQL/C can automatically convert DATETIME and INTERVAL values between database columns and host variables of character type char, string, or fixchar. HCL OneDB ESQL/C converts a DATETIME or INTERVAL value to a character string and then stores it in a host variable.

You can use HCL OneDB ESQL/C library functions to explicitly convert between DATE and DATETIME values.