mysql | problem with dates

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

mysql | problem with dates

Postby mihmih » Wed Apr 15, 2020 1:24 pm

Hi,

I used Base connected to mysql 5.X. I had to change the server and on the new server I installed mysql 8.X, copied the database there from the old server and connected to Base via mysql connector java 8.0.11. On the old server where was mysql 5.X i used mysql connector java 5.x. All forms, reports, queries in Base work as before. I have only one problem...

If I add or change any date via Base (forms, tables, queries), the date is saved as one day earlier in Mysql. When I do insert or update through workbech in mysqlu, everything is ok with dates.

Could this be a problem with the connecor? Can it be somehow set in Base or workbench so that the dates are saved correctly? Thank you in advance for any help.
LibreOffice 4.2 on Windows7
mihmih
 
Posts: 110
Joined: Wed Feb 18, 2015 9:21 pm

Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 2 guests