16.20 - AS OF - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

Specifies that the view is defined beginning at a specific point in time.

For information about temporal qualifiers, see Teradata Vantage™ Temporal Table Support , B035-1182 .

calendar_function
One of the embedded services system calendar functions.
For information about the embedded services calendar functions, see Teradata Vantage™ SQL Date and Time Functions and Expressions, B035-1211.
DATE expression
DATE AT TIME ZONE expression
A DATE or DATE AT TIME ZONE expression argument for the specified embedded services system calendar function.
You can specify a SELECT CURRENT_DATE or SELECT CURRENT_DATE AT TIME ZONE argument instead of an explicit DATE or DATE AT TIME ZONE expression argument.
TIMESTAMP expression
TIMESTAMP WITH TIME ZONE expression
A TIMESTAMP or TIMESTAMP WITH TIME ZONE expression argument for the specified embedded services system calendar function.
You can specify a SELECT CURRENT_TIMESTAMP or SELECT CURRENT_TIMESTAMP AT TIME ZONE argument instead of an explicit TIMESTAMP or TIMESTAMP WITH TIME ZONE expression argument.
system_calendar_name
An optional system calendar name used to define a different calendar than the one assigned to the current session.
For the definitions of the system calendars, see Teradata Vantage™ Data Dictionary, B035-1092.
You do not need to specify a system calendar name for week-related specific times because, for example, the previous Monday for a specified date is the same for all of the calendars.