| SQL adaptation guide for SQL SERVER 2005, 2008, 2012, 2014, 2016 / 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.
SQL SERVER does not provide a data type corresponding to the Informix® INTERVAL data type.
The INTERVAL data type is not well supported because the database server has no equivalent native data type. However, you can store into and retrieve from CHAR columns BDL INTERVAL values.