INTERVAL data type

Informix® 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 .

MySQL provides an INTERVAL data type, but it is totally different from the Informix INTERVAL type. For example, you specify an INTERVAL literal as follows:

25 years 2 months 23 days 

Solution

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.