date_specification - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

Specifies that the view is being defined AS OF a specific point in time.

calendar_function
One of the embedded services system calendar functions.
For more information about the embedded services calendar functions, see Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211.
date_expression
A DATE 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 [ WITH TIME ZONE ]
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.
calendar_name
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.