Johan van de Merwe
8 years
Johan van de Merwe
8 years

Change Excel Integer Date to MySQL Date

Posted . Visible to the public.

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 )

Johan van de Merwe
Last edit
Johan van de Merwe
Tags