Date data

Date data is a calendar date. The DataBlade API provides support for date values in both their text and binary representations.

Date text representation
Date binary representation
The SQL DATE data type holds the internal (binary) format of a decimal value. This value is an integer value that represents the number of days since December 31, 1899. Dates before December 31, 1899, are negative numbers, while dates after December 31, 1899, are positive numbers.
Transfers of date data (Server)
For date data to be portable when transferred across different computer architectures, the DataBlade API provides functions to handle type alignment and byte order.
Conversion of date representations
Both the DataBlade API library and the IBM® Informix® ESQL/C library provide functions that convert from the text (string) representation of a date value to the binary (internal) representation for DATE.
Operations on date data
The IBM Informix ESQL/C library provides functions to perform operations on DATE (mi_date) values.

Parent topic: Date and time data types