RE: DATE 5th OCT, 1582 not coming

From: Nikolay Kumanov <nkumanov_at_zgb.bg>
Date: Wed, 18 Oct 2000 13:28:14 +0300
Message-Id: <10653.119613@fatcity.com>

We can say that both Unix and Oracle are right (or wrong). The gregorian calendar was adopted in October, 1582 only in the catholic countries of Europe. Because of political reasons, protestant countries adopted the calendar in 18th century, England in September 1752. Eastern orthodox countries adopted the calendar in early 20th century - Bulgaria in 1916, Russia in 1918.

In order to be perfect, probably Oracle should use NLS_TERRITORY to calculate which days are omitted from the gregorian calendar :)

Dr. Nikolay Kumanov

MIS Manager, Zeitungsgruppe Bulgarien GmbH 47, Tsarigradsko chaussee, Sofia 1504, Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 mailto:nkumanov_at_zgb.bg

"Show me a completely smooth operation and I'll show you someone who's covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune"

-----Original Message-----
From: Rajesh Dayal [mailto:Rajesh_at_ohitelecom.com] Sent: Wednesday, October 18, 2000 1:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: DATE 5th OCT, 1582 not coming

There is a conflict ( if not deadlock).....
>>>

SQL> select to_date('10-Oct-1582','dd-Mon-yyyy') from dual ;

TO_DATE('10

---

15-OCT-1582 SQL> select to_date('10-Sep-1752','dd-Mon-yyyy') from dual;

TO_DATE('10

---

10-SEP-1752
<<<

I can also say Oracle is perfect
(at least this time) <grin> ;-))

After all we were not there in 1582 or Received on Wed Oct 18 2000 - 05:28:14 CDT