17.00 - Querying ANSI Bitemporal Tables - Teradata Database

Teradata Vantageā„¢ - ANSI Temporal Table Support

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

Special temporal syntax in the FROM clause of SELECT statements allows you to qualify queries by the time period to which they apply. Rows are only returned if they meet the temporal qualifications. These temporal qualifiers take precedence over other criteria that may be specified in a WHERE clause, which can be used to further restrict the rows returned by Teradata Database.