DATEDIFF()

函数说明

DATEDIFF() 函数返回两个日期之间的天数。

函数语法

1. > DATEDIFF(expr1,expr2)

参数释义

参数 说明
expr1, expr2 必要参数。expr1 和 expr2 参数是合法的日期或日期/时间表达式。只有值的日期部分参与计算。

示例

1. mysql> SELECT DATEDIFF('2007-12-31 23:59:59','2007-12-30');
2. +-------------------------------------------+
3. | datediff(2007-12-31 23:59:59, 2007-12-30) |
4. +-------------------------------------------+
5. |                                         1 |
6. +-------------------------------------------+
7. 1 row in set (0.00 sec)

9. mysql> SELECT DATEDIFF('2010-11-30 23:59:59','2010-12-31');
10. +-------------------------------------------+
11. | datediff(2010-11-30 23:59:59, 2010-12-31) |
12. +-------------------------------------------+
13. |                                       -31 |
14. +-------------------------------------------+
15. 1 row in set (0.00 sec)

1. create table t1(a INT,  b date);
2. insert into t1 values(1, "2012-10-11");
3. insert into t1 values(2, "2004-04-24");
4. insert into t1 values(3, "2008-12-04");
5. insert into t1 values(4, "2012-03-23");
6. insert into t1 values(5, "2000-03-23");
7. insert into t1 values(6, "2030-03-23");
8. insert into t1 values(7, "2040-03-23");

10. mysql> SELECT a, DATEDIFF('2022-10-9', b) from t1;
11. +------+------------------------+
12. | a    | datediff(2022-10-9, b) |
13. +------+------------------------+
14. |    1 |                   3650 |
15. |    2 |                   6742 |
16. |    3 |                   5057 |
17. |    4 |                   3852 |
18. |    5 |                   8235 |
19. |    6 |                  -2722 |
20. |    7 |                  -6375 |
21. +------+------------------------+
22. 7 rows in set (0.01 sec)