{ 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.