mysql | problem with dates
Posted: 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.
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.