Evaluates two Period expressions, or derived periods, or DateTime expressions to TRUE, FALSE, or UNKNOWN.
Syntax
period_spec [NOT] CONTAINS period_spec
- period_spec
-
{ period_expression | datetime_expression | derived_period }
- period_expression
-
Any expression that evaluates to a Period data type.
The Period expression must be comparable with the other expression. Implicit casting to a Period data type is not supported.
- datetime_expression
- An expression that evaluates to a DATE, TIME, or TIMESTAMP value.
- derived_period
- Any expression that evaluates to a Period data type.