Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
ESQL/C GuideThe topics explain how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities. The HCL® OneDB® ESQL/C Programmer's Manual explains how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
What is HCL OneDB™ ESQL/C?
Time data typesThese topics explain how to use date, datetime, and interval data types in the HCL® OneDB® ESQL/C program.
The SQL DATETIME and INTERVAL data types
Fetch and insert DATETIME and INTERVAL values

Fetch and insert DATETIME and INTERVAL values

When an application fetches or inserts a DATETIME or INTERVAL value, HCL OneDB™ ESQL/C must ensure that the qualifier field of the host variable is valid:

When an application fetches a DATETIME value into a datetime host variable or inserts a DATETIME value from a datetime host variable, it must ensure that the dt_qual field of the dtime_t structure is valid.
When an application fetches an INTERVAL value into an interval host variable or inserts an INTERVAL value from an interval host variable, it must ensure that the in_qual field of the intrvl_t structure is valid.