Re: DATE 5th OCT, 1582 not coming

From: David Peasley <david_at_adams.edu>
Date: Tue, 17 Oct 2000 12:05:06 -0600
Message-Id: <10652.119530@fatcity.com>

In 1582, Pope Gregor XIII ordered a calendar reform to correct the gradual error that had built up resulting from the Julian calendar being too long by 11 minutes or so. Part of the reform decreed that, October 4th, 1582 would be followed directly by October 15th.

Kinda' cool that Oracle knows that... :)

David Peasley
Database/System Administrator
Adams State College
Alamosa, CO 81102
719-587-7704

Sanjeev Sachdeva wrote:

> Here we are using following SQL:
>
> select to_date('5-OCT-1582','DD-MON-YYYY') from dual;
>
> which is returning 15-OCT-1582, instead of 05-OCT-1582
>
> Any Clue ?
>
> Sanjeev
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sanjeev Sachdeva
> INET: sanjeevs_at_delhi.tcs.co.in
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Oct 17 2000 - 13:05:06 CDT