MySQL日期时间时区

mytime.sql

CREATE TABLE `tbl_test` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

SELECT @@session.time_zone;
SELECT @@global.time_zone;

SET @@session.time_zone='+08:00';
INSERT INTO tbl_test (ts) VALUES ('2016-01-26 19:35:24');

SET @@session.time_zone='+02:00';
SELECT * FROM tbl_test;