{ period_expression [NOT] PRECEDES { period_expression | datetime_expression | derived_period } | datetime_expression [NOT] PRECEDES period_expression | derived_period [NOT] PRECEDES { derived_period | period_expression } }
Syntax Elements
- 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.