Introduction to ANSI Temporal Table Support | Teradata Vantage - Introduction to ANSI Temporal Table Support - Advanced SQL Engine - Teradata Database

ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
kit1592007446534.ditamap
dita:ditavalPath
kit1592007446534.ditaval
dita:id
B035-1186
lifecycle
previous
Product Category
Teradata Vantage™

Teradata Vantage™ is our flagship analytic platform offering, which evolved from our industry-leading Teradata® Database. Until references in content are updated to reflect this change, the term Teradata Database is synonymous with Teradata Vantage.

Teradata Vantage™ - ANSI Temporal Table Support describes the concepts fundamental to understanding Teradata support for ANSI temporal (time-aware) tables and data. This manual includes SQL language reference material and examples specific to the practical creation and manipulation of ANSI-compliant temporal tables.

For information on Teradata’s proprietary temporal tables, which have different capabilities than ANSI-compliant temporal tables, see Teradata Vantage™ - Temporal Table Support, B035-1182. For more information on the differences between the two temporal paradigms, see ANSI Temporal and Teradata Temporal.

Note that most temporal qualifiers and query syntax that is used with Teradata’s proprietary temporal tables can be used also on ANSI temporal tables.