RE: DATE 5th OCT, 1582 not coming

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 17 Oct 2000 14:23:44 -0400
Message-Id: <10652.119533@fatcity.com>

Our NLS-DATE-FORMAT =3D 'MM-DD-YYYY'
when I issue the query;
 select to_date('5-OCT-1582','DD-MON-YYYY') from dual; the returned results are;
10-15-1582
the date selection for OCT 1-14, 1582 all return OCT 15, 1582. We are on Ver7.3.4.0.1
The answer is: In 1582 Pope Gregory XIII (hence the name Gregorian Calendar) ordered ten days to be dropped from October, = thus restoring the vernalequinox at least to an average of the 20th of March, close to what it had been at the time of the = Council of Nicea. In order to correct for the loss of one day every 130 years, the new calendar dropped three leap years every = 400 years. Henceforth century years were leap years only if divisible by 400. 1600 and 2000 are leap years; 1700, 1800 = and 1900 are not.=20

ROR =AA=BF=AA >>> rajendra.jamadagni_at_espn.com 10/17/00 01:21PM >>> Works for me .....

SQL*Plus: Release 8.0.5.0.0 - Production on Tue Oct 17 12:16:26 2000
=20

(c) Copyright 1998 Oracle Corporation. All rights reserved.
=20

Enter user-name:
=20

Connected to:
Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production With the Partitioning, Objects and Parallel Server options PL/SQL Release 8.0.5.1.0 - Production
=20

SQL> select to_date('5-OCT-1582','DD-MON-YYYY') from dual;
=20

TO_DATE('

---

15-OCT-82
=20

SQL> exit
Disconnected from Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production=

With the Partitioning, Objects and Parallel Server options PL/SQL Release 8.0.5.1.0 - Production

HTH
Raj

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art ! Any opinion expressed here is personal and doesn't reflect that of ESPN = Inc.

---

This e-mail message is confidential, intended only for the named recipient(= s) above and may contain information that is privileged, attorney work = product or exempt from disclosure under applicable law. If you have = received this message in error, or are not the named recipient(s), please = immediately notify ESPN at (860) 766-2000 and delete this e-mail message = from your computer, Thank you.

---

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Jamadagni, Rajendra
  INET: rajendra.jamadagni_at_espn.com=20

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 Received on Tue Oct 17 2000 - 13:23:44 CDT