[ valid_time_qualifier [ AND transaction_time_qualifier ] | transaction_time_qualifier [ AND valid_time_qualifier ] | AS OF date_timestamp_expression ] select_into_statement
- valid_time_qualifier
{ CURRENT VALIDTIME | VALIDTIME AS OF date_timestamp_expression | { [ SEQUENCED | NONSEQUENCED ] VALIDTIME } [ period_expression ] }
- transaction_time_qualifier
{ { CURRENT | NONSEQUENCED } TRANSACTIONTIME | TRANSACTIONTIME AS OF date_timestamp_expression }
To ensure application portability to ANSI standards for temporal SQL, Teradata recommends explicit specification of all temporal qualifiers.