mysqli time zone

On one server, when I run:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2009-05-30 16:54:29 |
+---------------------+
1 row in set (0.00 sec)

On another server:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2009-05-30 20:01:43 |
+---------------------+
1 row in set (0.00 sec)

There are three places where the timezone might be set in MySQL:

In the file "my.cnf" in the [mysqld] section
default-time-zone='+00:00'

@@global.time_zone variable

To see what value they are set to:
SELECT @@global.time_zone;

To set a value for it use either one:
SET GLOBAL time_zone = '+8:00';
SET GLOBAL time_zone = 'Europe/Helsinki';
SET @@global.time_zone = '+00:00';

شارك الموضوع

إقرأ أيضًا