17.05 - Omitting a Valid-Time Qualifier - Teradata Database

Teradata Vantage™ - Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1182-170K

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