Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Has Oracle actually erased the birth of Christ from the calendar?
This seems like an interesting bug. It was around in 8.1.5. I've just
checked 8.1.6 and same again. What do all you SQL gurus think?
Look at this log from a SQL*Plus session and tell me I've got it wrong. The way I see it there is a serious calculation problem with dates that span the birth of Christ.
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL> select to_char(to_date('1721423','j'),'syyyy/mm/dd') from dual select to_char(to_date('1721423','j'),'syyyy/mm/dd') from dual
*
SQL> c /23/24/
1* select to_char(to_date('1721424','j'),'syyyy/mm/dd') from dual
SQL> /
TO_CHAR(TO_
SQL> select to_char(to_date('-0001/12/31','syyyy/mm/dd'),'j') from dual;
TO_CHAR
SQL> select to_char(to_date('1721058','j'),'syyyy/mm/dd') from dual; select to_char(to_date('1721058','j'),'syyyy/mm/dd') from dual
*
SQL> ed
Wrote file afiedt.buf
1* select to_char(to_date('-0001/12/31','syyyy/mm/dd') +0,'j,
syyyy/mm/dd') from dual
SQL> /
TO_CHAR(TO_DATE('-00
SQL> c /+0/+1/
1* select to_char(to_date('-0001/12/31','syyyy/mm/dd') +1,'j,
syyyy/mm/dd') from dual
SQL> /
TO_CHAR(TO_DATE('-00
SQL> c /+1/+366/
1* select to_char(to_date('-0001/12/31','syyyy/mm/dd') +366,'j,
syyyy/mm/dd') from dual
SQL> /
TO_CHAR(TO_DATE('-00
SQL> c /+366/+367/
1* select to_char(to_date('-0001/12/31','syyyy/mm/dd') +367,'j,
syyyy/mm/dd') from dual
SQL> /
TO_CHAR(TO_DATE('-00
This begs the question:
Is Larry really God? If pope Gregory struggled to get away with 10 days guess you would have to be God to get away with 367 days! Received on Fri Nov 09 2001 - 07:00:56 CST