Teradata SQL supports DATE, TIME, TIMESTAMP, TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE, and Interval data types for defining periods of time.
Note: DATE, TIME, TIMESTAMP, TIME WITH TIME ZONE, and TIMESTAMP WITH TIME ZONE data types are collectively referred to as DateTime data types.
For information about Period data types, which are used to define a period with a beginning time and an end time, see Chapter 5: “Period Data Types.”