Informix DataBlade API Programmer's Manual Using Date and Time Data Types

In This Chapter

Date Data

Date Text Representation

Date Binary Representation

Transferring Date Data

Converting Date Between Text and Binary

DataBlade API Functions for Date Conversion

ESQL/C Functions for Date Conversion

Performing Operations on Date Data

Date, Time, and Interval Data

Date, Time, and Interval Text Representation

Date, Time, and Interval Binary Representation

The DATETIME Data Type

The INTERVAL Data Type

datetime.h Header File

Fetching and Inserting DATETIME and INTERVAL Values

Selecting and Inserting into mi_datetime Variables

Selecting and Inserting into mi_interval Variables

Implicit Data Conversion

Transferring Date and Time Data

Converting Date or Time Between Text and Binary

DataBlade API Functions for Date and Time Conversion

ESQL/C Functions for Date, Time, and Interval Conversion

Performing Operations on Date and Time Values

Obtaining Date and Time Type Information

Qualifier of a Date or Time Data Type

Precision of a Date or Time Data Type

Scale of a Date or Time Data Type