Problem Description
Does anyone know if there is a function to obtain the server's time zone setting 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 |
+--------------------+---------------------+
If MySQL can't know the exact `time_zone` being used, that's fine - we can also involve `PHP` as long as I can get valid info (not like `SYSTEM`)
AI-Generated Solution
Powered by LMSouq AI · GPT-4.1-mini
Analyzing problem and generating solution…
Was this solution helpful?