Introduction to ANSI Temporal Table Support | Teradata Vantage - Introduction to ANSI Temporal Table Support - Analytics Database - Teradata Vantage

ANSI Temporal Table Support

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
jqu1628112571823.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esa1472244798285
lifecycle
latest
Product Category
Teradata Vantage™

Using ANSI Temporal Table Support

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

Why Would I Use this Content?

Learn to create, query, and modify ANSI temporal tables, ANSI valid-time tables, and ANSI bitemporal tables, and what is needed to use temporal tables with Teradata Vantage™.

How Do I Use this Content?

Use this guide as a reference to learn about creating and querying ANSI-compliant temporal tables, and administering ANSI-compliant temporal table support.

How Do I Get Started?

Get started with using temporal tables by learning about Teradata Vantage support for ANSI temporal tables and temporal concepts.

References to Other Relevant Content

Teradata Vantage™ - Temporal Table Support, B035-1182

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.