17.10 - Converting Transaction-Time Tables into ANSI System-Time Tables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1186-171K
Language
English (United States)

Three methods for converting Teradata proprietary transaction-time tables into ANSI compliant system-time tables are described here. For more information on the differences between Teradata Temporal and ANSI Temporal tables, see ANSI Temporal and Teradata Temporal. For more information on Teradata’s proprietary non-ANSI-compatible temporal tables and syntax, see Temporal Table Support.