mysql query date erro

Question

Why is the difference between the time of the database query and the result 13 hours？

5eeker · Accepted Answer · 2022-08-23 04:57:03Z

0

Please check the timezone set in your DB configuration, I think it could be due to that, to check the timezone in mysql you can refer below documentation :

SELECT @@GLOBAL.time_zone, @@SESSION.time_zone;

https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html

answered Aug 23, 2022 at 4:57

5eeker

1,0371 gold badge9 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql query date erro

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related