INTERVAL data type

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.

Genero db 3.61 does not provide a data type similar to Informix® INTERVAL but, since version 3.80, Genero db supports DATETIME and INTERVAL data types as Informix.

Solution

Use Genero db version 3.80 if you want to store Informix-like INTERVAL values, with full support of DATETIME arithmetic.