Re: DATE 5th OCT, 1582 not coming

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