15.10 - Querying ANSI Valid-Time Tables - Teradata Database

Teradata Database ANSI Temporal Table Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Programming Reference
featnum
B035-1186-015K

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.

Note: For valid-time tables, these qualifiers are Teradata Database extensions to ANSI. ANSI does not support AS OF, BETWEEN ... AND, and FROM ... TO temporal qualifiers for queries of valid-time tables.