'-0001/01/01' is that in 1 BC or 2 BC

'0000'Year in the Oracle is illegal. '0000/01/01'to'0000/12/31' is illegal. But the'0001/01/01'-'-0001/12/31'result is 367, that is to say, the implicit'0000' year is 366 days. If'0000'is BC 1 years, should not be a leap year. And check the'-0004'-'-0003'found that'-0004' is a leap year, the other is not a leap year.
So I am very confused, what'-0001'said in 1 BC or 2 bc. If it is in the year 1 BC, why is between'0001/01/01'and'-0001/12/31' will be how the time difference of 367 days? And was a leap year? If it is in the year 2 BC, it should not be a leap year, and if'-0004'is expressed in 5 BC is not a leap year?

Started by William at November 18, 2016 - 1:01 AM

So heavy? How come no one help.?

Posted by William at November 30, 2016 - 1:51 AM

Help you to the top, suggested some practical.

Posted by Tamara at December 07, 2016 - 1:55 AM

Should not be ah ~-0001-12-31 is 0001-1-1.~

Posted by Chester at December 19, 2016 - 2:53 AM

Said Ming ah, actually this:
SQL> select to_date('0001-01-01','yyyy-mm-dd')-to_date('-0001-12-31','syyyy-mm-dd') DTE from dual;
DTE
----------
367

Posted by William at December 27, 2016 - 3:38 AM

select to_char(to_date('00010101','yyyymmdd')-1,'yyyymmdd') from dual;
The implementation of the SQL Oracle found here really is wrong
You had better to calculate the data with other measures.
You are doing archaeological project? Even with such pre dates

Posted by Elaine at December 30, 2016 - 3:46 AM