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

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.