Change Excel Integer Date to MySQL Date

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 )
Last update: Tue, 13 Sep 2022 14:32:15