mysql timestamp时间运算

1
2
3
4
5
6
7
8
mysql> select updated_at,DATE_ADD(updated_at,INTERVAL 1 SECOND) from fs_thread limit 2;
+---------------------+----------------------------------------+
| updated_at | DATE_ADD(updated_at,INTERVAL 1 SECOND) |
+---------------------+----------------------------------------+
| 2008-10-09 10:22:32 | 2008-10-09 10:22:33 |
| 2008-10-12 23:53:04 | 2008-10-12 23:53:05 |
+---------------------+----------------------------------------+
2 rows in set (0.00 sec)