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:
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

Options: ReplyQuote


Subject
Views
Written By
Posted
734
December 17, 2017 03:34AM
Re: String to Date conversion
480
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.