Re: Date Question

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 Mar 2006 12:38:40 -0800
Message-ID: <1142973520.410791.233390@t31g2000cwb.googlegroups.com>

Dave, Oracle has a year zero problem in its Julian Calendar. This is fairly well known and I have even read a write up by someone knowledgable about the problem and why Oracle will not fix it (backwards compatibility).

Here is a thread or two of interest from the Oracle newsgroup archives

http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/60387d878475929a/39ceb38848607976?lnk=st&q=year+zero+group%3Acomp.databases.oracle.*&rnum=3&hl=en#39ceb38848607976

http://groups.google.com/group/comp.databases.oracle.tools/browse_thread/thread/a7cdd5bf44bb7bbf/a3c42db601091974?lnk=st&q=year+zero+group%3Acomp.databases.oracle.*&rnum=9&hl=en#a3c42db601091974

I am thinking the really interesting write up may have been by Howard J Rogers. You might try his web site.

HTH -- Mark D Powell -- Received on Tue Mar 21 2006 - 14:38:40 CST