MySQL Forums
Forum List  »  MySQL for Excel

Re: date format Mysql for Excel in Excel 2016 dosn't work
Posted by: Barbara Cioppa
Date: December 05, 2016 08:31AM

Thank you Javier.

While I'm waiting new version, I've tried to capture datas with trigger and it works if I use workbench but not with excel. I found that excel doesn't use ' ' for data field i.e. if I modify query, putting single quotes between data ('2016/05/01 12:11:00' ....) it works because trigger do what it was write for, that's convert dataTime in data format.
How can I setting mySql for Excel to write single quote on value of that column before it writes query?

Thank you again

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: date format Mysql for Excel in Excel 2016 dosn't work
391
December 05, 2016 08:31AM


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.