MySQL Forums
Forum List  »  MySQL for Excel

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

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

Options: ReplyQuote

Written By
date format Mysql for Excel in Excel 2016 dosn't work
November 21, 2016 11:07AM

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.