MySQL一些函数

DATE_SUB:

日期与时间函数--

mysql> SELECT DATE_SUB('1998-01-01 00:00:00',INTERVAL '1 1:1:1' DAY_SECOND);
+---------------------------------------------------------------+
| DATE_SUB('1998-01-01 00:00:00',INTERVAL '1 1:1:1' DAY_SECOND) |
+---------------------------------------------------------------+
| 1997-12-30 22:58:59                                           | 
+---------------------------------------------------------------+
1 row in set (0.04 sec)

mysql> SELECT DATE_SUB('1998-01-02', INTERVAL 31 DAY);
+-----------------------------------------+
| DATE_SUB('1998-01-02', INTERVAL 31 DAY) |
+-----------------------------------------+
| 1997-12-02                              | 
+-----------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_SUB(NOW(), INTERVAL 31 DAY);
+----------------------------------+
| DATE_SUB(NOW(), INTERVAL 31 DAY) |
+----------------------------------+
| 2013-04-03 15:42:04              | 
+----------------------------------+
1 row in set (0.00 sec)
mysql> exit;
Bye
[root@localhost shelldemo]# date
2013年 05月 04日 星期六 15:42:52 CST
[root@localhost shelldemo]#