MySQL Forums
Forum List  »  Newbie

MySQL Time Different to Server
Posted by: Max Hugen
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?

MTIA

Options: ReplyQuote


Subject
Written By
Posted
MySQL Time Different to Server
July 13, 2014 09:56PM


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.