17.10 - Omitting a Transaction-Time Qualifier - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1182-171K
Language
English (United States)

If no temporal qualifier is specified in the transaction-time dimension in the statement, the system uses the temporal qualifier of the session. If none is specified for the session, the default of CURRENT is assumed and only rows that are open participate in further processing.