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.

Netezza® implements the INTERVAL data type in a different way than Informix does.

Solution

The Informix INTERVAL types of the day-time class can be mapped to the native Netezza INTERVAL type, for day to second time interval storage.

Since Netezza does not clearly distinguish year-month interval class, such types are converted to CHAR(50) by the Netezza driver.

Important: Netezza (V6 at the time of writing) has several bugs regarding the INTERVAL type; we do not recommend using this type until Netezza has fixed these problems.