Re: Remove Date overlap duplicates

From: Sebastian Kolski <>
Date: Thu, 08 Oct 2009 17:21:09 +0200
Message-ID: <hal015$uvk$>

yossarian wrote:
> Sebastian Kolski wrote:
>>> date '2007-01-01'

>> It is ANSI SQL-92 Standard.

> Is it documented?

Oracle® Database SQL Language Reference 11g Release 2 (11.2)
Part Number E10592-03
3 Basic Elements of Oracle SQL
Datetime Literals
"To specify a DATE value as a literal, you must use the Gregorian calendar. You can specify an ANSI literal, as shown in this example:

DATE '1998-12-25'" etc

no link because iam using local copy of docs and gives me timeout right now Received on Thu Oct 08 2009 - 10:21:09 CDT

Original text of this message