Re: Remove Date overlap duplicates
From: yossarian <yossarian99_at_operamail.com>
Date: Thu, 08 Oct 2009 14:44:32 +0200
Message-ID: <4acddeb1$0$6836$5fc30a8_at_news.tiscali.it>
CarlosAL wrote:
Date: Thu, 08 Oct 2009 14:44:32 +0200
Message-ID: <4acddeb1$0$6836$5fc30a8_at_news.tiscali.it>
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. Received on Thu Oct 08 2009 - 07:44:32 CDT