Mysql Time zone is correct but time is 5 minutes earlier.(Asia/Kolkatta) time zone

Question

I am using NOW() and the 'datetime' data type. Getting correct date but incorrect time. Like 50 mins earlier time from the current time.How to save the accurate time of the time zone.

eg: SELECT NOW() This query gives 2021-08-19 17:40:17. But the actual time in my zone was 2021-08-19 17:45:17

Does anyone have any idea why this five minutes difference occurs?

It gives the time 2021-08-19 23:03:02. But actual time in my time zone is 2021-08-19 17:39:02 — Selsons Software, Aug 19 '21 at 12:09
Sounds like the clock on your mysql machine is 5 minutes slow, rather than it being a time zone issue as such. — Jon Skeet, Aug 19 '21 at 12:21
You may try to configure using this instructions: https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql — Leonardo, Dec 10 '21 at 16:01

score 0 · Answer 1 · answered Dec 09 '21 at 07:01

0

It was a problem with the MySQL machine. It is five minutes slow. Solved the issue by adding five minutes in the insert query. now() + interval 5 minute

answered Dec 09 '21 at 07:01

Selsons Software

23
6

Mysql Time zone is correct but time is 5 minutes earlier.(Asia/Kolkatta) time zone

1 Answers1