17.10 - ANSI Temporal Tables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

This section describes the major differences between Teradata’s proprietary implementation of temporal tables and syntax, which is described in this document, and Teradata’s implementation of ANSI/ISO compliant temporal tables, which is described in Teradata Vantage™ - ANSI Temporal Table Support, B035-1186. It also describes three methods that can be used to convert transaction-time tables into ANSI-compliant system-versioned system-time tables.