MySQL Forums :: Newbie :: MySQL Time Different to Server
MySQL Time Different to Server
Date: July 13, 2014 09:56PM
In MySQL 5.6.17, I have discovered that timestamp fields have times that are incorrect by 3 hours - looks like a Time Zone issue.
The MySQL function Now() returns, for example: 2014-07-13 23:47:07
However, the server shows the time as: 2014-07-13 20:47:07
After some Googling, I ran SELECT @@global.time_zone, @@session.time_zone; and both values were 'SYSTEM' as I had expected.
MySQL is clearly NOT using the server's system date/time however.
NOTE: when this server was originally set up, the Time Zone was incorrect (US Eastern Time), and some time later (after setting up MySQL), I corrected it to US Pacific Time. A 3 hour difference.
Can anyone suggest a way to fix this pls?
Sorry, only registered users may post in this forum.
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.