Start of change

Querying system-period temporal data

Querying a system-period temporal table can return results for a specified point or period in time. The results can include current values and previous historic values.

To query a temporal table, you can specify the time criteria several ways:
  • in a query explicitly using a SYSTEM_TIME period specification,
  • in a query implicitly using the CURRENT TEMPORAL SYSTEM_TIME system register, or
  • in a view definition.
End of change