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.