15.00 - Overview - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)
Last Update
2018-09-24

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