I use it in Oracle and notice there are 10 days missed, for example:
ORCL> select to_date('4/10/1582','dd/mm/yyyy') SHOW_DATE from dual
SHOW_DATE -------------- 04/10/1582 ORCL> select to_date('4/10/1582','dd/mm/yyyy') + 1 SHOW_DATE from dual
SHOW_DATE -------------- 15/10/1582 Say What? the date after 4/10/1582 is 15/10/1582.
But in MySQL i try it but i didn't see this case, example:
mysql