| SQL adaptation guide For SQLite 3.5.x, 3.6.x / Data dictionary | |
Informix's INTERVAL data type stores a value that represents a span of time. INTERVAL types are divided into two classes: year-month intervals and day-time intervals.
SQLite 3 does not provide a data type similar to Informix® INTERVAL.
It is not recommended that you use the INTERVAL data type because SQLite 3 has no equivalent native data type. This would cause problems when doing INTERVAL arithmetic on the database server side. However, INTERVAL values can be stored in CHAR(50) columns.