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.