Skip to content

Latest commit

 

History

History
33 lines (24 loc) · 1.31 KB

datediff.md

File metadata and controls

33 lines (24 loc) · 1.31 KB

datediff

功能

计算两个日期的差值，结果精确到天。

expr1 和 expr2 参数必须是合法的日期或日期/时间表达式。

注意：只有日期部分参与计算。

语法

INT DATEDIFF(DATETIME expr1,DATETIME expr2)

示例

select datediff(CAST('2007-12-31 23:59:59' AS DATETIME), CAST('2007-12-30' AS DATETIME));
+-----------------------------------------------------------------------------------+
| datediff(CAST('2007-12-31 23:59:59' AS DATETIME), CAST('2007-12-30' AS DATETIME)) |
+-----------------------------------------------------------------------------------+
|                                                                                 1 |
+-----------------------------------------------------------------------------------+

select datediff(CAST('2010-11-30 23:59:59' AS DATETIME), CAST('2010-12-31' AS DATETIME));
+-----------------------------------------------------------------------------------+
| datediff(CAST('2010-11-30 23:59:59' AS DATETIME), CAST('2010-12-31' AS DATETIME)) |
+-----------------------------------------------------------------------------------+
|                                                                               -31 |
+-----------------------------------------------------------------------------------+