Best results in other decks

between 2 dates select latest_date, lowest_date, floor(datediff(date(latest_date), date(lowest_date)) / 365) from your_table

Converts something like 45353 into 2012-11-10 update as tb set tb.your_mysql_datefield = date_add(date('1899-12...