Converts something like 45353 into 2012-11-10
update as tb
set tb.your_mysql_datefield = date_add(date('1899-12-31'), interval (tb.your_excel_int_date_field - 1) day )
Converts something like 45353 into 2012-11-10
update as tb
set tb.your_mysql_datefield = date_add(date('1899-12-31'), interval (tb.your_excel_int_date_field - 1) day )