An optional modifier used to define the temporal properties of the AS OF clause.
For more information about temporal qualifiers, see Temporal Table Support, B035-1182.
Example: Creating a Business Cycle View Using the AS OF Request Modifier
An AS OF view can be useful when a business cycle is measured at specific times such as last month, last quarter, last year, and similar cases.
For example, you can use this view to generate a report as of every month beginning.
CREATE VIEW v1 AS VALIDTIME AS OF TD_MONTH_BEGIN((SELECT CURRENT_DATE), 'Teradata') SELECT c1, c2, vt1 FROM vt1;
For more information about the AS OF request modifier, see SQL Data Manipulation Language, B035-1146. For more information about TD_MONTH_BEGIN and other embedded services system functions, see SQL Functions, Operators, Expressions, and Predicates, B035-1145.