17.10 - Argument 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)

The function is overloaded and can be invoked with one, two, or three arguments.

The first argument can be one of the following data types:

  • DATE
  • TIMESTAMP
  • TIMESTAMP WITH TIME ZONE

The second argument can be one of the following system-defined calendars (TERADATA, ISO, or COMPATIBLE) or NULL

The third argument can be one of the following data types:

  • TIME
  • TIME WITH TIME ZONE
  • NULL