Re: date format Mysql for Excel in Excel 2016 dosn't work

[Barbara Cioppa]

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