pt_simultaneous_excluded_end_instants
ptrb edited this page May 29, 2013
·
1 revision
pt_simultaneous_excluded_end_instants( PostTIME , PostTIME ) : boolean
Checks out if two objects share at least one simultaneous point in time. This function is quite similar to pt_simultaneous, with the difference that this function excludes any periods end instant from the calculation.
SELECT pt_simultaneous_excluded_end_instants('2012/2012-2-6T12:00:00.000','2012-2-6T12:00:00.000/2013');
-- result
f
SELECT pt_simultaneous_excluded_end_instants('2012/2012-2-6T12:00:00.001','2012-2-6T12:00:00.000/2013');
-- result
t
SELECT pt_simultaneous_excluded_end_instants('2013-5-4T8:2','R10/2013-5-3/PT8H/PT16H');
-- result
f
| CAL | TCS | ORD ---|---|---|--- TM_Instant | ✔ | ✔ | ✗ TM_Period | ✔ | ✔ | ✗ MultiInstant | ✔ | ✔ | ✗ MultiPeriod | ✔ | ✔ | ✗ RegularMultiInstant | ✔ | ✔ | - RegularMultiPerid | ✔ | ✔ | - ✔ : Processable
✗ : Call will cause an error
∼ : Callable without error, but returns only a pseudo result