Re: Remove Date overlap duplicates

From: yossarian <>
Date: Thu, 08 Oct 2009 14:44:32 +0200
Message-ID: <4acddeb1$0$6836$>

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:

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. Received on Thu Oct 08 2009 - 07:44:32 CDT

Original text of this message