17.10 - ANSI Temporal Concepts - 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)

This section defines important concepts and terms related to Teradata ANSI temporal table support.

Temporal tables store and maintain information with respect to time. Using temporal tables, Vantage can process statements and queries that include time-based reasoning. ANSI temporal tables include one or two special derived columns that represent different time dimensions. These dimensions are used for different purposes.