CODEWITHSUNDEEP
phpmysqlgmt
iLaYa ツ
iLaYa ツ

Reputation: 4017

GMT time and mysql NOW() is giving 2 minutes difference

When i was checking the GMT time here it was 05:40:00, at the same time i ran the below query in mysql,

SET time_zone='+00:00'; // to get GMT time
SELECT NOW();

It was 05:37:50 from above query. So in mysql i am getting around 2 minutes time difference from GMT. It has to give 05:40:00 instead of 05:37:50. How to resolve this?

Thanks for your valuable time.

Upvotes: 0

Views: 246

Answers (1)

mvp
mvp

Reputation: 116227

I cannot reproduce this on my Linux box.

Most likely that machine that MySQL server is running on does not have properly configured time service.

Depending of what OS your MySQL is running, you should setup time sync. For Linux, it would we ntpd package.

Upvotes: 1

Related Questions