Period Data Type Usage | Temporal Table Support | Teradata Vantage - 17.10 - Period Data Type Usage - 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)

Both temporal and nontemporal tables support Period data types and literals.

With respect to temporal tables:
  • transaction-time columns must have a data type of PERIOD(TIMESTAMP(6) WITH TIME ZONE) or be a derived period column where the component begin and end time columns are both PERIOD(TIMESTAMP(6) WITH TIME ZONE).
  • Valid-time columns can have a Period or derived period data type of PERIOD(DATE), PERIOD(TIMESTAMP[(n)]), or PERIOD(TIMESTAMP[(n)] WITH TIME ZONE).

For more information on Period and DateTime data types, see Teradata Vantage™ - Data Types and Literals, B035-1143.