How to get MySQL time zone?

Under certain circumstances it is relevant to know the timezone in which your date is being stored in a Relational Database System, for example MySQL. One of the easiest ways to know is just by running following command:

Step 1. Login to MySQL

mysql -u root -p

Step 2. Run a “select” query to get the timezone

mysql> SELECT @@global.time_zone;

The output of the previous command should be something like this:

+--------------------+
| @@global.time_zone |
+--------------------+
| SYSTEM             |
+--------------------+
1 row in set (0.00 sec)

As you can see we are getting a SYSTEM value which means that our MySQL instance is using the timezone set in the configuration file: my.cnf.

See you next time!

Alex Arriaga