DATETIME Considerations

In Informix®, a valid DATETIME data type can be either yyyy-mo-dd hh:mi:ss:ff... or any contiguous subset of the previous string, for example, mo-dd hh. Any column that is defined to contain such a subset does not accept a full ANSI DATETIME.

Therefore, the DATETIME type generated within the data file corresponds to the DATETIME type defined for the actual column in a table. To be consistent with the Informix DDL, you should define the following in the derivation for every DATETIME column (except the default):

Expression
Description
Hour to Fraction(5)
A partial ANSI DATETIME type, starting with hours and ending with fractions, with a precision of 5.
Hour to Second
A partial ANSI DATETIME type, starting with hours and ending with seconds.
Month to Minute
A partial ANSI DATETIME type, starting with months and ending with minutes.
Year to Fraction(3)
The default value. Full ANSI DATETIME, with a precision of 3.