MySQL now() is 1 hour behind

Question

I am trying to get all the votes from TODAY THE CURRENT , and I have almost achieved that with the following mysql query, but there's one problem.

This code gets me the votes from today:

SELECT COUNT(*) FROM votes WHERE `when` > CURRENT_DATE

but when inserting into mysql using now() the now() is 1 hour behind my timezone (Europe/London) how can I fix that?

Thanks.

http://stackoverflow.com/questions/930900/how-to-set-time-zone-of-mysql — nathanmac, Aug 21 '15 at 22:44

score 2 · Answer 1 · answered Aug 21 '15 at 23:00

2

You will need to populate your timezone tables. If you are on linux, you can do so by running the following command :

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

You may need to know your root password. You then can run the following query as root :

SET GLOBAL time_zone = 'Europe/London';

answered Aug 21 '15 at 23:00

trex005

That is why you need to populate your timezone tables. Did you do that step? – trex005 Aug 22 '15 at 01:59
1

Didn't work for me, after setting ``time_zone`` to "Europe/Berlin", ``NOW()`` is still 1 hour behind. Edit: Nevermind, the timezone in the docker container running MySQL was also incorrect. – Philipp Ludwig Mar 23 '18 at 10:43

nathanmac · Answer 2 · 2015-08-21T22:47:35.913

0

mysql> SET GLOBAL time_zone = 'America/New_York';

edited Aug 21 '15 at 22:47

answered Aug 21 '15 at 22:46

nathanmac

2 Answers2