Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DATE 5th OCT, 1582 not coming

Re: DATE 5th OCT, 1582 not coming

From: <elkinsl_at_flash.net>
Date: Tue, 17 Oct 2000 11:45:13 -0500 (CDT)
Message-Id: <10652.119510@fatcity.com>


Due to a change from Julian to Gregorian calendar in 1582?

....Omission of 10 calendar days, the 4th of October 1582 was followed directly by the 15th of October 1582 in the new calendar....

Here are some links:

http://www.maa.mhn.de/Scholar/calendar.html
http://ourworld.compuserve.com/homepages/khagen/GregConv.html
http://www.pietro.org/Astro_Util_StaticDemo/FDetailDateConversions.htm

L. Elkins

On Tue Oct 17 10:35:33 2000, ORACLE-L_at_fatcity.com 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 ?
Received on Tue Oct 17 2000 - 11:45:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US