Tests the ending bound value of a temporal table system-time or transaction-time column to see whether the row is open (the ending bound value IS UNTIL_CLOSED) or closed (the ending bound value IS NOT UNTIL_CLOSED).
Syntax
END ( { period_expression | derived_period } )
IS [NOT] UNTIL_CLOSED
- period_expression
- The Period expression to be converted.
- derived_period
- Any expression that evaluates to a Period data type.