Re: Remove Date overlap duplicates
From: Sebastian Kolski <sebastian.kolski_at_gmail.com>
Date: Thu, 08 Oct 2009 17:21:09 +0200
Message-ID: <hal015$uvk$1_at_achot.icm.edu.pl>
yossarian wrote:
> Sebastian Kolski wrote:
>
>
>
> Is it documented?
Date: Thu, 08 Oct 2009 17:21:09 +0200
Message-ID: <hal015$uvk$1_at_achot.icm.edu.pl>
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
Literals
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 oracle.com gives me timeout right now Received on Thu Oct 08 2009 - 10:21:09 CDT