Re: DATE 5th OCT, 1582 not coming

Tim,

You are right!!

The Pope did "throw" out 10 days in October 1582.

For more information, you can take a look at this site:

http://www.nationalpost.com/content/features/millennium/122399mill6.html

Winnie :P

Gee.. at least there is no holiday in the first week of October! :P

"Tim Sawmiller" <sawmillert_at_state.mi.us>@fatcity.com on 10/17/2000 10:32:42 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: Re: DATE 5th OCT, 1582 not coming

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