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.