17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - ANSI Temporal Table Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
  • [AS] VALIDTIME is an extension to ANSI. It is required to create valid-time tables in Vantage. The [AS] VALIDTIME clause allows SELECT statements on valid-time tables to use special temporal qualifiers (AS OF, BETWEEN ... AND, FROM TO, CONTAINED IN), which ANSI does not support on valid-time tables. For more information, see Querying ANSI Valid-Time Tables.
  • Dropping the valid-time derived period column from a valid-time table deletes all history and future rows from the table unless the WITHOUT DELETE option is used.