DATEDIFF

Description

Calculates the difference between two given dates.

Syntax

DATEDIFF(<expr1>, <expr2>)

Parameters

Parameter	Description
<expr1>	The minuend (the date to be subtracted from)
<expr2>	The subtrahend (the date to subtract)

Return Value

Returns the value of expr1 - expr2, with the result rounded to the nearest day.

Examples

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 |
+-----------------------------------------------------------------------------------+