Add new rows to ANSI system-time 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 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.