MySQL Forums
Forum List  »  MySQL for Excel

Advanced Search
New Topic

date format Mysql for Excel in Excel 2016 dosn't work
Posted by: Barbara Cioppa
Date: November 21, 2016 11:07AM

Hello,
I usually connect my Mysql DB with Excel, only with "Excel 2016" I have problem with date field, i.e. I've setted column in Excel as customize date:"aaaa/mm/gg", as in other version of Excel, because my table attempts a DATE field,and Excel show me the correct value in my sheet (even if I click on it I can see it's only aaaa/mm/gg) but when I will send query (update or insert), Excel 2016 unexpectly put hh:mm:ss (00:00:00)at the end of my field and DBMS reply with error 1064: substantially it expect a date field not a dateTime.
I've tried to ask to MS but they don't know why, I'm in deadlock, someone can help me please?
Thank you

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
date format Mysql for Excel in Excel 2016 dosn't work
2950
Barbara Cioppa
November 21, 2016 11:07AM
Re: date format Mysql for Excel in Excel 2016 dosn't work
1119
Javier Treviño
November 30, 2016 09:30AM
Re: date format Mysql for Excel in Excel 2016 dosn't work
1172
Barbara Cioppa
December 05, 2016 08:31AM
Re: date format Mysql for Excel in Excel 2016 dosn't work
1372
Javier Treviño
December 06, 2016 11:13AM
Re: date format Mysql for Excel in Excel 2016 dosn't work
972
Hauke Wedekind
January 11, 2017 10:26PM
Re: date format Mysql for Excel in Excel 2016 dosn't work
1044
Javier Treviño
January 26, 2017 12:44AM


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.