The Datetime Interval DATA type stores and MANIPULATE DATES, times, and intervals.

A variable with date and time data type stores values called datetimes. A variable with interval data type stores values called intervals.

Here are the field NAMES:

YEAR

• Valid Datetime Value: 4712 to 9999 (excluding year 0)
• Valid Interval Value: Any non-zero integer

MONTH

• Valid Datetime Value: 01 to 12
• Valid Interval Value: 0 to 11

DAY 

• Valid Datetime Value: 01 to 31
• Valid Interval Value: Any non-zero integer

HOUR

• Valid Datetime Value: 00 to 23
• Valid Interval Value: 0 to 23

MINUTE

• Valid Datetime Value: 00 to 59
• Valid Interval Value: 0 to 59

SECOND

• Valid Datetime Value: 00 to 59.9(n), where 9(n) is the precision of time fractional seconds
• Valid Interval Value: 0 to 59.9(n), where 9(n) is the precision of interval fractional seconds

TIMEZONE_HOUR

• Valid Datetime Value: -12 to 14 (range accommodates daylight savings time changes)
• Valid Interval Value: Not Applicable

TIMEZONE_MINUTE

• Valid Datetime Value: 00 to 59
• Valid Interval Value: Not Applicable

TIMEZONE_REGION

• Valid Datetime Value: Found in the dynamic performance view V$TIMEZONE_NAMES
• Valid Interval Value: Not Applicable

TIMEZONE_ABBR

• Valid Datetime Value: Found in the dynamic performance view V$TIMEZONE_NAMES
• Valid Interval Value: Not Applicable