17.00 - Overview - Teradata Database

Teradata Vantageā„¢ - ANSI Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1186-170K

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

Temporal tables store and maintain information with respect to time. Using temporal tables, Teradata Database 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.