Tests whether two time periods overlap each another.
Syntax
time_period_expression OVERLAPS time_period_expression
- time_period_expression
-
{ ( { datetime_expression, { datetime_expression | interval_expression } | row_subquery } ) | period_expression | derived_expression } - datetime_expression
- A start and end DateTime.
- interval_expression
- An end DateTime.
- row_subquery
-
A subquery that selects the same number of expressions as are specified in the expression or list of expressions.
The subquery cannot specify a SELECT AND CONSUME statement.
- period_expression
- The Period expression to be converted.
- derived_period
- Any expression that evaluates to a Period data type.