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