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.