ANSI DateTime data types include:
- DATE
- TIME
- TIME WITH TIME ZONE
- TIMESTAMP
- TIMESTAMP WITH TIME ZONE
Interval Data Types
There are two categories of ANSI Interval data types:
- Year-Month Intervals, which include:
- YEAR
- YEAR TO MONTH
- MONTH
- Day-Time Intervals, which include:
- DAY
- DAY TO HOUR
- DAY TO MINUTE
- DAY TO SECOND
- HOUR
- HOUR TO MINUTE
- HOUR TO SECOND
- MINUTE
- MINUTE TO SECOND
- SECOND