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


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.