apoc.temporal.overlap

Function Apoc Extended

apoc.temporal.overlap(start1,end1,start2,end2,$config) - Check whether the two temporal spans (start1-end1 and start2-end2) overlap or not

Signature

apoc.temporal.overlap(start1 :: ANY?, end1 :: ANY?, start2 :: ANY?, end2 :: ANY?, config = {} :: MAP?) :: BOOLEAN?

Input parameters

Name Type Default

start1

ANY?

null

end1

ANY?

null

start2

ANY?

null

end2

ANY?

null

config

MAP?

{}

Config parameters

The function support the following config parameters:

Table 1. Config parameters
name type default description

acceptAdjacentSpans

boolean

false

also considers adjacent spans

Usage Examples

adjacent spans with default config
RETURN apoc.temporal.overlap(
    date("1999"),
    date("2000"),
    date("2000"),
    date("2001"))
AS value
Table 2. Results
value

false
adjacent spans with config acceptAdjacentSpans: true
RETURN apoc.temporal.overlap(
    date("1999"),
    date("2000"),
    date("2000"),
    date("2001"),
    {acceptAdjacentSpans: true} )
AS value
Table 3. Results
value

true
duration spans
RETURN apoc.temporal.overlap(
    time("00:01"),
    time("01:01"),
    time("00:00"),
    time("00:02") )
AS value
Table 4. Results
value

true
non-comparable spans
RETURN apoc.temporal.overlap(
    date("1998"),
    date("1999"),
    time("00:00"),
    time("00:02") )
AS value
Table 5. Results
value

null