这里的技巧是知道什么是列类型date_last_active
。我有足够的经验,TIMESTAMP
并且DATETIME
知道一个翻译(并尊重)MysqL time_zone会话变量,而另一个没有。
MysqL> SET SESSION time_zone = 'America/New_York';
Query OK, 0 rows affected (0.00 sec)
MysqL> create table timetest ( dt datetime NULL, ts timestamp NOT NULL DEFAULT 0 );
Query OK, 0 rows affected (0.06 sec)
MysqL> INSERT INTO timetest ( dt, ts ) VALUES ( UTC_TIMESTAMP(), UTC_TIMESTAMP() );
Query OK, 1 row affected (0.00 sec)
MysqL> INSERT INTO timetest ( dt, ts ) VALUES ( Now(), Now() );
Query OK, 1 row affected (0.00 sec)
MysqL> SELECT * FROM timetest;
+---------------------+---------------------+
| dt | ts |
+---------------------+---------------------+
| 2009-06-27 17:53:51 | 2009-06-27 17:53:51 |
| 2009-06-27 13:53:54 | 2009-06-27 13:53:54 |
+---------------------+---------------------+
2 rows in set (0.00 sec)
MysqL> set session time_zone='UTC';
Query OK, 0 rows affected (0.00 sec)
MysqL> SELECT * FROM timetest;
+---------------------+---------------------+
| dt | ts |
+---------------------+---------------------+
| 2009-06-27 17:53:51 | 2009-06-27 21:53:51 |
| 2009-06-27 13:53:54 | 2009-06-27 17:53:54 |
+---------------------+---------------------+
2 rows in set (0.00 sec)
所以,这是我的工作:
希望这足以弄清楚如何解决此问题。如果您还有其他问题,请告诉我。