User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle Data Types - INTERVAL YEAR TO MONTH
Versions: Oracle 11g, 10g and 9i
Oracle - INTERVAL YEAR TO MONTH | |
---|---|
Syntax | INTERVAL YEAR [(p)] TO MONTH |
Data | Stores a period of time represented as years and months |
Range | 0 ⇐ p ⇐ 9 |
Defaults | p is 2 |
Version Differences | Oracle 9i and later - INTERVAL YEAR TO MONTH data type is available |
Standards | Oracle Extension |
Oracle INTERVAL YEAR TO MONTH - Equivalents in Other Databases
Database | Data Type and Conversion |
---|---|
PostgreSQL | INTERVAL |
Informix | INTERVAL YEAR(p) TO MONTH |
HP Neoview | INTERVAL YEAR(p) TO MONTH |
Related Data Types in Oracle
Data Types | ||
---|---|---|
Datetime | DATE | TIMESTAMP(p) |
Intervals | INTERVAL DAY(p1) TO SECOND(p2) |
All Data Types