Getting timezone value in mysql

Question

How can i get current timezone in mysql .

possible duplicate of http://stackoverflow.com/questions/2934258/how-do-i-get-the-current-time-zone-of-mysql — Shakti Singh, Jan 31 '11 at 11:58

score 0 · Answer 1 · answered Jan 31 '11 at 11:58

0

May be i'm don't undestand question but... http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html

answered Jan 31 '11 at 11:58

Alexey Sviridov

3,360
28
33

score 0 · Answer 2 · answered Jan 31 '11 at 20:59

It's the first (and only) column of the first (and only) row of the result of this SELECT query:

SELECT @@global.time_zone;

If you want the session time zone you can use:

SELECT @@session.time_zone;

The result is like this:

mysql> SELECT @@global.time_zone;
+--------------------+
| @@global.time_zone |
+--------------------+
| Europe/Paris       |
+--------------------+
1 row in set (0.00 sec)

Getting timezone value in mysql

2 Answers2