DATE and DATETIME data types

Informix^® provides two data types to store date and time information:

DATE = for year, month and day storage.
DATETIME = for year to fraction(1-5) storage.

SQLite 3 does not have a native type for date/time storage, but you can use data/time type names and functions based on the string representation of dates and times. The date/time values are stored in the TEXT native type. The date/time functions of SQLite are based on standard DATE (YYYY-MM-DD), TIME (hh:mm:ss) and TIMESTAMP (YYYY-MM-DD hh:mm:ss) concepts.

Solution

Informix DATE type is not translated, it will be used as is by SQLite.

Informix DATETIME HOUR TO SECOND type is translated to TIME.

Informix DATETIME YEAR TO FRACTION and all other combinations are translated to TIMESTAMP.