17.10 - Introduction to Temporal Table Support - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Teradata provides the built-in capabilities that are required in a temporal database management system. Temporal data types and temporal statements facilitate creating applications that need to represent time and the information that changes over time.

Feature Description
Temporal data types The period data type represents an anchored duration of time.
Temporal column attributes In addition to user-defined time, which can be represented by using DateTime data types such as DATE and TIMESTAMP, Teradata temporal table support adds the capability to add valid-time and transaction-time dimensions to tables, by means of temporal column attributes.
Temporal statements Temporal variations of existing statements let you create and alter temporal tables, and query and modify data that changes over time.
Queries and modifications can include temporal qualifiers that reference a time dimension and act as criteria or selectors on the data. They affect only the data that meets the time criterion. Temporal DML statements can be generally qualified as:
  • CURRENT, affecting only data that is currently in effect
  • SEQUENCED, affecting only data that is in effect for a specified time period
  • AS OF, affecting only data that is in effect at a specified point in time
  • NONSEQUENCED, where the time dimension is ignored, the table is treated as a nontemporal table, and the DML statement is applied to all data in the table