mysql>SELECT (DATE_ADD(FROM_UNIXTIME(0), INTERVAL (600002000) MINUTE_SECOND)),from_unixtime(600002000)
+----------------------------------------------------------------------------+------------------------------------+
| (DATE_ADD(FROM_UNIXTIME(0), INTERVAL (600002000) MINUTE_SECOND)) | from_unixtime(600002000) |
+----------------------------------------------------------------------------+------------------------------------+
| 1989-01-05 19:13:20 | 1989-01-05 19:13:20 |
+----------------------------------------------------------------------------+------------------------------------+
mysql>SELECT (DATE_ADD(FROM_UNIXTIME(0), INTERVAL (554742000) MINUTE_SECOND)),from_unixtime(554742000)
+----------------------------------------------------------------------------+------------------------------------+
| (DATE_ADD(FROM_UNIXTIME(0), INTERVAL (554742000) MINUTE_SECOND)) | from_unixtime(554742000) |
+----------------------------------------------------------------------------+------------------------------------+
| 1987-07-31 23:00:00 | 1987-08-01 00:00:00 |
+----------------------------------------------------------------------------+------------------------------------+为什么2个结果会不一样呢,第二条会差1个小时
+----------------------------------------------------------------------------+------------------------------------+
| (DATE_ADD(FROM_UNIXTIME(0), INTERVAL (600002000) MINUTE_SECOND)) | from_unixtime(600002000) |
+----------------------------------------------------------------------------+------------------------------------+
| 1989-01-05 19:13:20 | 1989-01-05 19:13:20 |
+----------------------------------------------------------------------------+------------------------------------+
mysql>SELECT (DATE_ADD(FROM_UNIXTIME(0), INTERVAL (554742000) MINUTE_SECOND)),from_unixtime(554742000)
+----------------------------------------------------------------------------+------------------------------------+
| (DATE_ADD(FROM_UNIXTIME(0), INTERVAL (554742000) MINUTE_SECOND)) | from_unixtime(554742000) |
+----------------------------------------------------------------------------+------------------------------------+
| 1987-07-31 23:00:00 | 1987-08-01 00:00:00 |
+----------------------------------------------------------------------------+------------------------------------+为什么2个结果会不一样呢,第二条会差1个小时
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货