Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
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