MySQL timestampdiff 和 timestampadd 函数

 

1. mysql> select TIMESTAMPDIFF(day,‘2012-08-24‘,‘2012-08-30‘);  
2. +----------------------------------------------+  
3. | TIMESTAMPDIFF(day,‘2012-08-24‘,‘2012-08-30‘) |  
4. +----------------------------------------------+  
5. |                                            6 |   
6. +----------------------------------------------+  
7. 1 row in set (0.00 sec)  

[sql] view plain copy  

1. mysql> select TIMESTAMPDIFF(MINUTE,‘2012-08-24 09:00:00‘,‘2012-08-30 12:00:00‘);  
2. +-------------------------------------------------------------------+  
3. | TIMESTAMPDIFF(MINUTE,‘2012-08-24 09:00:00‘,‘2012-08-30 12:00:00‘) |  
4. +-------------------------------------------------------------------+  
5. |                                                              8820 |   
6. +-------------------------------------------------------------------+  
7. 1 row in set (0.01 sec)  

二，TIMESTAMPADD   语法： TIMESTAMPADD(interval,int_expr,datetime_expr)   说明： 将整型表达式int_expr 添加到日期或日期时间表达式 datetime_expr中。式中的interval和上文中列举的取值是一样的。 [sql] view plain copy  

1. mysql> select TIMESTAMPADD(MINUTE,8820,‘2012-08-24 09:00:00‘);  
2. +-------------------------------------------------+  
3. | TIMESTAMPADD(MINUTE,8820,‘2012-08-24 09:00:00‘) |  
4. +-------------------------------------------------+  
5. | 2012-08-30 12:00:00                             |   
6. +-------------------------------------------------+  
7. 1 row in set (0.00 sec)  

MySQL timestampdiff 和 timestampadd 函数

标签：mod   word   interval   comment   表示   row   body   说明   http