数据库时区

最新推荐文章于 2024-03-24 12:34:38 发布

原创最新推荐文章于 2024-03-24 12:34:38 发布 · 598 阅读

0 ·

CC 4.0 BY-SA版权

数据库原理与Mysql 专栏收录该内容

22 篇文章

订阅专栏

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)