Overview ANSI DateTime Data Types 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