Re: DATE 5th OCT, 1582 not coming

Tim,

    Actually, that correction was made in Sept. 1752:

srcdco>cal 9 1752

      September 1752
Sun Mon Tue Wed Thu Fri Sat

         1 2 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30

I played with the below problem and discovered that it gets the date correct for 10/1/1582 - 10/4/1582 and again starting with 10/16/1582. All of the dates between 10/5/1582 and 10/15/1582 return 10/15/1582. Looks like some kind of bug (or feature).

Tim Sawmiller wrote:

> That's around the time that a Pope wanted to fix the calendar to get it to match the seasons and threw out about 10 days in October for a particular year (may very well have been 1582).
>
> >>> sanjeevs_at_delhi.tcs.co.in 10/17/00 11:35AM >>>
> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tim Sawmiller
> INET: sawmillert_at_state.mi.us
>
> 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).

--
Scott Canaan (srcdco_at_rit.edu)
"Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer