- CURRENT VALIDTIME
- Specifies that the session valid-time qualifier is current.
- VALIDTIME AS OF date_timestamp_expression
- Specifies that when a SELECT statement refers to a temporal table but omits a valid-time qualifier, the default behavior extracts a snapshot of the table in the valid-time dimension AS OF the date or timestamp value specified by date_timestamp_expression.
date_timestamp_expression can be a constant, scalar UDF, scalar subquery, or business calendar function that evaluates to a date or timestamp value.
- VALIDTIME SEQUENCED VALIDTIME
- Specifies that the session valid-time qualifier is sequenced.
- NONSEQUENCED VALIDTIME
- Specifies that the session valid-time qualifier is nonsequenced.
- period_expression
- Specifies the period of applicability for the sequenced or nonsequenced session valid-time qualifier. The period value must be a constant expression or built-in function and cannot reference any columns.
- CURRENT TRANSACTIONTIME
- Specifies that the session transaction-time qualifier is current.
- TRANSACTIONTIME AS OF date_timestamp_expression
- Specifies that when a SELECT statement refers to a temporal table but omits a transaction-time qualifier, the default behavior extracts a snapshot of the table in the transaction-time dimension AS OF the date or timestamp value specified by date_timestamp_expression.
date_timestamp_expression can be a constant, scalar UDF, scalar subquery, or business calendar function that evaluates to a date or timestamp value.
- NONSEQUENCED TRANSACTIONTIME
- Specifies that the session transaction-time qualifier is nonsequenced.
- AS OF date_timestamp_expression
- Specifies that when a SELECT statement refers to a temporal table but omits the valid-time qualifier, transaction-time qualifier, or both, the default behavior extracts a snapshot of the table in the valid-time dimension, transaction-time dimension, or both dimensions AS OF the value specified by date_timestamp_expression.
date_timestamp_expression can be a constant, scalar UDF, scalar subquery, or business calendar function that evaluates to a date or timestamp value.
- ANSIQUALIFIER
- This is the default for users of ANSI/ISO-compatible temporal tables and syntax.