Change Date Format to YYYY-MM-DD Before Importing into MySQL Database

Problem: when importing from csv or ods file, the date imported into MySQL Database Server is messed up, e.g. DD-MM-YYYY in csv or ods file when imported into does not show correctly as dd-mm-yy.

 

Cause: MySQL Database Server only accepts date format as YYYY-MM-DD, it will not convert DD-MM-YY to YYYY-MM-DD . Refer to https://dev.mysql.com/doc/refman/8.0/en/datetime.html

 

Solution: a quick solution is to format the date in as csv or ods file as YYYY-MM-DD before import.