On May 21, 4:49 am, "Andrus" <kobrule(dot)(dot)(dot)(at)hot(dot)ee> wrote:
> I'm using this for emplyment, vacation, illness etc. period calculation.
> OVERLAPS produces invalid result in this case for DATE as discussed in other
> thread.
>
> select doverlaps(date '2007-01-01',date '2007-01-02',date '2007-01-02',date
> '2007-01-04');
>
> returns FALSE
>
> When first period end and second period start dates are the the same,
> doverlaps() must return TRUE.
>
> Andrus.
OR $2 = $3