Re: DATE 5th OCT, 1582 not coming

From: <Brian_McQuillan_at_gelco.com>
Date: Tue, 17 Oct 2000 12:46:22 -0400
Message-Id: <10652.119506@fatcity.com>

Curious this,
it seems to do this for any date form Oct 5th 1582 thru to Oct 15th 1582 , the 4th and 16th are returned ok.
Could this be an Oracle version of the well known UNIX calendar for 1752 where it goes from Sep 2nd to Sep 14th and no 3rd to 13th (caused by the switch from the Julian to Gregorian
Calendars (or was it vice versa??))
and if so who switched their calendars in October 1582 ? Brian.

"Sanjeev Sachdeva" <sanjeevs_at_delhi.tcs.co.in> on 10/17/2000 11:35:33 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Brian McQuillan/GELCO)

Subject: DATE 5th OCT, 1582 not coming

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). Received on Tue Oct 17 2000 - 11:46:22 CDT