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
1 |
mysql -u root -p |
Step 2. Run a “select” query to get the timezone
1 |
mysql> SELECT @@global.time_zone; |
The output of the previous command should be something like this:
1 2 3 4 5 6 |
+--------------------+ | @@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.
Would you like to know how to locate your my.cnf file? Then visit: How to find my.cnf MySQL configuration file in Linux?
See you next time!
Alex Arriaga