Teradata SQL supports DATE, TIME, TIMESTAMP, TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE, and Interval data types for defining periods of time.
DATE, TIME, TIMESTAMP, TIME WITH TIME ZONE, and TIMESTAMP WITH TIME ZONE data types are collectively called 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 Period Data Types.
- DateTime Fields
- Time Zones
- Daylight Saving Time
- DATE Data Type
- TIME Data Type
- TIMESTAMP Data Type
- TIME WITH TIME ZONE Data Type
- TIMESTAMP WITH TIME ZONE Data Type
- INTERVAL YEAR Data Type
- INTERVAL YEAR TO MONTH Data Type
- INTERVAL MONTH Data Type
- INTERVAL DAY Data Type
- INTERVAL DAY TO HOUR Data Type
- INTERVAL DAY TO MINUTE Data Type
- INTERVAL DAY TO SECOND Data Type
- INTERVAL HOUR Data Type
- INTERVAL HOUR TO MINUTE Data Type
- INTERVAL HOUR TO SECOND Data Type
- INTERVAL MINUTE Data Type
- INTERVAL MINUTE TO SECOND Data Type
- INTERVAL SECOND Data Type