as_of_clause - Teradata Vantage

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

calendar_function

One of the embedded services system calendar functions (see Calendar Functions).

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 System Calendar View.

You need not 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.