Example:
PERIOD(startTime1,endTime1) PRECEDES PERIOD(startTime2,endTime2)
PERIOD(startTime1, endTime1) CONTAINS PERIOD (startTime2, endTime2)
<period-expression> :=
<left-period> <half-period-predicate> <right-period>
<half-period-predicate> :=
<period-predicate> [ <left-period> <half-period-predicate> ]
<period-predicate> :=
EQUALS
| [ STRICTLY ] CONTAINS
| [ STRICTLY ] OVERLAPS
| [ STRICTLY | IMMEDIATELY ] PRECEDES
| [ STRICTLY | IMMEDIATELY ] SUCCEEDS
| [ STRICTLY | IMMEDIATELY ] LEADS
| [ STRICTLY | IMMEDIATELY ] LAGS
<left-period> := <bounded-period>
<right-period> := <bounded-period> | <timestamp-expression>
<bounded-period> := [ PERIOD ] ( <start-time>, <end-time> )
<start-time> := <timestamp-expression>
<end-time> := <timestamp-expression>
Example:
PERIOD(startTime1,endTime1) PRECEDES PERIOD(startTime2,endTime2)
PERIOD(startTime1, endTime1) CONTAINS PERIOD (startTime2, endTime2)