ANSI DateTime Data Types | SQL Date/Time Functions & Expressions | Vantage - 17.10 - ANSI DateTime Data Types - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1211-171K
Language
English (United States)
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