15.10 - temporal_modifier - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.