INSERT Statement (ANSI Valid-Time Table Form) | Teradata Vantage - 17.10 - INSERT (ANSI Valid-Time Table Form) - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1186-171K
Language
English (United States)

Add new rows to temporal tables.

Syntax

There is no special temporal syntax for inserting rows into temporal tables. Use the standard SQL INSERT statement. However, note the following:
  • You must include values for the beginning and ending bound columns that constitute the valid-time derived period column.
  • As for any type of derived period column in the database, you cannot insert Period type values for the derived period column itself.