How do I get the current time zone of MySQL?

by

Anyone knows if there is such a function in MySQL?

UPDATE

This doesn’t output any valid info:

mysql> SELECT @@global.time_zone, @@session.time_zone;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| SYSTEM             | SYSTEM              |
+--------------------+---------------------+

Or maybe MySQL itself can’t know exactly the time_zone used,that’s fine, we can involve PHP here, as long as I can get valid info not like SYSTEM…

18 Answers
18

Leave a Comment