User Documentation
Ispirer Capabilities - Informix Migration
Pricing
Informix Dynamic Server (IDS) Data Types - INTERVAL DAY/TIME
Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x
| Informix - INTERVAL | |
|---|---|
| Syntax | INTERVAL [largest_qualifier[(n)] TO smallest_qualifier] |
| Data | Period of time in days and/or time. The largest_qualifier and smallest_qualifier can be DAY, HOUR, MINUTE, SECOND and FRACTION provided that smallest_qualifier does not specify a larger time unit than largest_qualifier, they can be the same, for example, INTERVAL DAY TO DAY n is the precision for largest_qualifier, optional |
| Range | 1 ⇐ n ⇐ 9 (n ⇐ 5 if largest_qualifier is FRACTION) |
| Default | n is 2 |
| Standards | Informix SQL Extension |
Example:
CREATE TABLE t_interval (c1 INTERVAL DAY(3) TO HOUR);
Informix INTERVAL - Equivalents in Other Databases
| Database | Data Type and Conversion | |
|---|---|---|
| Oracle | INTERVAL DAY(p1) TO SECOND(p2) | |
| PostgreSQL | INTERVAL | |
| HP Neoview | INTERVAL day-time | |
Related Data Types in Informix
| Data Types | |||
|---|---|---|---|
| Datetime | DATE | DATETIME | INTERVAL year-month |
All Data Types