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 HCL OneDB™ ESQL/C Programmer's Manual explains how to use , 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
Converting data for datetime valuesYou can use the library functions dtcvasc(), dtcvfmtasc(), dttoasc(), and dttofmtasc() to explicitly convert between DATETIME column values and character strings.

Converting data for datetime values

You can use the library functions dtcvasc(), dtcvfmtasc(), dttoasc(), and dttofmtasc() to explicitly convert between DATETIME column values and character strings.

About this task

For example, you can perform conversions between the DATETIME and DATE data types with library functions and intermediate strings.

To convert a DATETIME value to a DATE value:

Procedure

Use the dtextend() function to adjust the DATETIME qualifier to year to day.
Apply the dttoasc() function to create a character string in the form yyyy-mm-dd.
Use The rdefmtdate() function with a pattern argument of yyyy-mm-dd to convert the string to a DATE value.