MySQL中TIMESTAMPDIFF和TIMESTAMPADD函数的用法

 TIMESTAMPDIFF(day,‘2012-08-24‘,‘2012-08-30‘);  

+----------------------------------------------+   

| TIMESTAMPDIFF(day,‘2012-08-24‘,‘2012-08-30‘) |  

+----------------------------------------------+   

|                                            6 |   

+----------------------------------------------+   

1 row in set (0.00 sec)  

 

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和上文中列举的取值是一样的。

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函数的用法

标签：