Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Data Types - INTERVAL DAY TO SECOND
Versions: Oracle 11g, 10g and 9i
| Oracle - INTERVAL DAY TO SECOND | |
|---|---|
| Syntax | INTERVAL DAY [(p1)] TO SECOND [(p2)] |
| Data | Stores a period of time in days, hours, minutes, seconds and fractional seconds |
| Range | 0 ⇐ p1 ⇐ 9, 0 ⇐ p2 ⇐ 9 |
| Defaults | p1 is 2, p2 is 6 (microseconds) |
| Version Differences | Oracle 9i and later - INTERVAL DAY TO SECOND data type is available |
| Standards | Oracle Extension |
Oracle INTERVAL DAY TO SECOND - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| PostgreSQL | INTERVAL |
| Informix | INTERVAL DAY(p1) TO FRACTION(p2) |
| HP Neoview | INTERVAL DAY(p1) TO SECOND(p2) |
Related Data Types in Oracle
| Data Types | ||
|---|---|---|
| Datetime | DATE | TIMESTAMP(p) |
| Intervals | INTERVAL YEAR(p) TO MONTH | |
All Data Types