MYSQL计算时间间隔——————TimeStampDiff()

最新推荐文章于 2024-08-07 22:27:36 发布

ninja

最新推荐文章于 2024-08-07 22:27:36 发布

阅读量4.2k

点赞数

分类专栏： MySql

MySql 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

函数TimeStampDiff()是MySQL本身提供的可以计算两个时间间隔的函数，语法为：TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)，其中unit单位有如下几种，分别是：FRAC_SECOND (microseconds),SECOND,MINUTE,HOUR,DAY,WEEK,MONTH,QUARTER, orYEAR。

例如：

mysql> select timestampdiff(week,’2009-01-24′,’2009-06-20′);
+———————————————————–+
| timestampdiff(week,’2009-01-24′,’2009-06-20′)       |
+———————————————————–+
|                                                                       21|
+———————————————————–+
1 row in set (0.00 sec)mysql> select timestampdiff(day,’2009-01-24′,’2009-06-20′);
+———————————————————-+
| timestampdiff(day,’2009-01-24′,’2009-06-20′)        |
+———————————————————-+
|                                                                    147|
+———————————————————-+
1 row in set (0.00 sec)mysql> select timestampdiff(month,’2009-01-24′,’2009-06-20′);
+————————————————————-+
| timestampdiff(month,’2009-01-24′,’2009-06-20′)       |
+————————————————————-+
|                                                                           4|
+————————————————————-+
1 row in set (0.00 sec)mysql> select timestampdiff(year,’2009-01-24′,’2009-06-20′);
+———————————————————–+
| timestampdiff(year,’2009-01-24′,’2009-06-20′)        |