Re: Remove Date overlap duplicates
From: Sebastian Kolski <sebastian.kolski_at_gmail.com>
Date: Thu, 08 Oct 2009 15:58:31 +0200
Message-ID: <hakr66$q8d$1_at_achot.icm.edu.pl>
yossarian wrote:
> CarlosAL wrote:
>
>
> Thank you for sharing this info, never heard of it, very useful!
>
> While googling for details I found this article:
>
> http://oraclesponge.wordpress.com/2008/06/12/the-overlaps-predicate/
>
> The author uses this construct everywhere:
>
> date '2007-01-01'
>
> I never saw this syntax and I'm not able to found documentation about it
> (perhaps I'm using the wrong keywords...). Can you point me to a link?
>
> Thank you.
>
> Kind regards, Y.
Date: Thu, 08 Oct 2009 15:58:31 +0200
Message-ID: <hakr66$q8d$1_at_achot.icm.edu.pl>
yossarian wrote:
> CarlosAL wrote:
>
>> You may use OVERLAPS predicate, which is an ANSI SQL standard used in >> others RDBMS (Teradata, for example). It is in Oracle (undocumented >> though) since version 10(?).
>
> Thank you for sharing this info, never heard of it, very useful!
>
> While googling for details I found this article:
>
> http://oraclesponge.wordpress.com/2008/06/12/the-overlaps-predicate/
>
> The author uses this construct everywhere:
>
> date '2007-01-01'
>
> I never saw this syntax and I'm not able to found documentation about it
> (perhaps I'm using the wrong keywords...). Can you point me to a link?
>
> Thank you.
>
> Kind regards, Y.
It is ANSI SQL-92 Standard. I think Oracle supports it since version 9.
Best regards, Sebastian Received on Thu Oct 08 2009 - 08:58:31 CDT