Re: String to Date conversion

[Javier Treviño]

Hi Sajid,
You should take a look at the official documentation for MySQL:
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html

Maybe one of those functions converts dates to a numeric format in the same way Excel does, although I doubt it.

The easiest thing would be to export those records to Excel, convert in Excel and update the data back to MySQL. This is easy to do with MySQL for Excel.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team