Originally posted by patnams
Another interesting thing is in year 1752. A about 12 days ares in September. This is becasue they changed from Gregorian(?) to Julian(?) formats .

Oracle does not take care of this.

On unix do "cal 1752" and look for September, from 2 it jumps to 14.
It's all in the link I gave above: http://www.tondering.dk/claus/cal/no...00000000000000

Note that different parts of the USA changed at VERY different times - Oracle apparently went over in 1582, whereas UNIX was a little late:
Code:
declare
ans varchar2(50);
begin
for i IN 1..20 loop
select to_char(to_date('01-OCT-1582','DD-MON-YYYY')+i,'DD-MON-YYYY') into ans from dual;
dbms_output.put_line(ans);
end loop;
end;
/
Bill Gates gets leap years wrong - type 60 into an Excel sheet and format it as Date.