Implicit data conversion
You can select a DATETIME or INTERVAL column value into a character
variable. The DataBlade
API converts
the DATETIME or INTERVAL column value to a character string before
it stores it in the character variable. This character string conforms
to the ANSI SQL standards for DATETIME and INTERVAL values.
Important: HCL Informix® products
do not support automatic data conversion from DATETIME and INTERVAL
column values to numeric (mi_double_precision, mi_integer,
and so on) variables.
You can also insert a DATETIME or INTERVAL column value from a character variable. The DataBlade API uses the data type and qualifiers of the column value to convert the character value to a DATETIME or INTERVAL value. It expects the character string to contain a DATETIME or INTERVAL value that conforms to ANSI SQL standards.
If the conversion fails, the DataBlade
API sets
the SQLSTATE status variable to an error-class code (and SQLCODE status
variable to a negative value) and the update or insert operation fails.
Important: HCL Informix products
do not support automatic data conversion from numeric and mi_date variables
to DATETIME and INTERVAL column values.