LMSouq
database Open

How do I get the current time zone of MySQL?

US
user198729
1 month ago
3 views
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

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base