MySQL Forums :: Newbie :: MySQL Time Different to Server

Advanced Search

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?


Options: ReplyQuote

Subject Written By Posted
MySQL Time Different to Server Max Hugen 07/13/2014 09:56PM
Re: MySQL Time Different to Server Rick James 07/15/2014 09:33PM
Re: MySQL Time Different to Server Max Hugen 07/15/2014 10:18PM

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.