I've imported a CSV file into mysql with dates in format dd/mm/yyyy.

I now need a query to convert it from text to date format yyy-mm-dd.

mysql date
Edit
Report