INSERT Statement (ANSI System-Time Table Form) | Teradata Vantage - INSERT (ANSI System-Time Table Form) - Analytics Database - Teradata Vantage

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 system-time derived period column.
• Values entered for the system-time columns will be automatically replaced by the database, so can be any values of any type. The value for the beginning system-time column will be replaced by the value of the TEMPORAL_TIMESTAMP function at the time of the insertion, and the ending system-time value will be replaced automatically with the maximum system timestamp value, 9999-12-31 12:59:59.999999+00:00.
• As for any type of derived period column in the database, you cannot insert Period type values for the derived period column itself.