数据库时区

mysql> select @@global.time_zone, @@session.time_zone;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| SYSTEM             | SYSTEM              |
+--------------------+---------------------+
1 row in set (0.06 sec)


mysql> set time_zone = '+00:00';
Query OK, 0 rows affected (0.07 sec)


mysql> select @@session.time_zone;
+---------------------+
| @@session.time_zone |
+---------------------+
| +00:00              |
+---------------------+
1 row in set (0.40 sec)


mysql> use test;
Database changed
mysql> create table ts_test (ts timestamp);
Query OK, 0 rows affected (0.07 sec)


mysql> insert into ts_test (ts) values (NULL);
Query OK, 1 row affected (0.07 sec)


mysql> select * from ts_test;
+---------------------+
| ts                  |
+---------------------+
| 2016-06-28 14:08:09 |
+---------------------+
1 row in set (0.07 sec)


mysql> set time_zone ='+0.2:00';
ERROR 1298 (HY000): Unknown or incorrect time zone: '+0.2:00'
mysql> set time_zone = '+02:00';
Query OK, 0 rows affected (0.06 sec)


mysql> select * from ts_test;
+---------------------+
| ts                  |
+---------------------+
| 2016-06-28 16:08:09 |
+---------------------+
1 row in set (0.07 sec)