RE: DATE 5th OCT, 1582 not coming

Since you people are fascinated by the missing days. The truth of the matter is that the locals demanded their days back!!!! Seems the landlords wanted the rent at the end of the month even tho nobody had worked enough days to get the rent money!!!!

-----Original Message-----
From: Scott Canaan [mailto:srcdco_at_ritvax.isc.rit.edu] Sent: Wednesday, October 18, 2000 10:16 AM To: Multiple recipients of list ORACLE-L Subject: 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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: srcdco_at_ritvax.isc.rit.edu

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