MySQL Forums
Forum List  »  MySQL for Excel

Re: String to Date conversion
Posted by: Javier Treviño
Date: January 15, 2018 12:40PM

Hi Sajid,
You should take a look at the official documentation for MySQL:

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

Options: ReplyQuote

Written By
December 17, 2017 03:34AM
Re: String to Date conversion
January 15, 2018 12:40PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.