mysql> show variables like '%time_zone%'; +------------------+--------+ | Variable_name | Value | +------------------+--------+ | system_time_zone | CST | | time_zone | SYSTEM | +------------------+--------+ 2 rows in set (0.00 sec)把这两个变量设置正确即可
检查你的变量设置 mysql> show variables like '%zone%'; +------------------+---------------------+ | Variable_name | Value | +------------------+---------------------+ | system_time_zone | China Standard Time | | time_zone | SYSTEM | +------------------+---------------------+ 2 rows in set (0.00 sec)mysql>
插入的时间会转化成本地时区的时间存放...你看看你的时区是什么..
show variables like 'time_zone';如果是system 就说明这个和主机的时区是一样的。你检查下你OS的时区吧...中国的时区是东八区(+8:00)
set GLOBAL time_zone= 你现在所在的时区..
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | CST |
| time_zone | SYSTEM |
+------------------+--------+
2 rows in set (0.00 sec)把这两个变量设置正确即可
都是一样的,即mysql设置的时区的当前时间,格式为2010-08-17 15:40:50
mysql> show variables like '%zone%';
+------------------+---------------------+
| Variable_name | Value |
+------------------+---------------------+
| system_time_zone | China Standard Time |
| time_zone | SYSTEM |
+------------------+---------------------+
2 rows in set (0.00 sec)mysql>