OVERLAPS

Description

The OVERLAPS predicate determines whether two chronological periods overlap. A chronological period is specified by a pair of date-time expressions (the first expression specifies the start of a period; the second specifies its end).

OVERLAPS is not supported in Snowflake.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

SELECT * from T1 where 
(cast('2016-03-17' as DATE), cast('2016-03-21' as DATE)) 
OVERLAPS
cast('2016-03-20' as DATE), cast('2016-03-22' as DATE));

Snowflake

Code

SELECT * from T1 where 
/*** MSC-ERROR - MSCEWI1021 - OVERLAPS NOT SUPPORTED ***/
 PUBLIC.OVERLAPS_UDF('(cast(\'2016-03-17\' as DATE),       cast(\'2016-03-21\' as DATE)) OVERLAPS       (cast(\'2016-03-20\' as DATE), cast(\'2016-03-22\' as DATE))');

Related EWIs

1. MSCEWI1021: Not supported.