SQL Server DATEDIFF () function

Server Date function

Definition and usage

The DATEDIFF () function returns the number of days between two dates.

Grammar

DATEDIFF (datepart,startdate,enddate)

The startdate and enddate parameters are valid date expressions.

The datepart parameter can be the following value:

DatePart	Abbreviations
Years	YY, yyyy
Quarter	QQ, Q
Month	MM, M
The day of the year	Dy, y
Day	DD, D
Week	WK, WW
Week	DW, W
Hours	hh
Minutes	MI, n
Seconds	SS, S
Milliseconds	Ms
Subtle	MCs
Na-Sec	Ns

Example 1

Use the following SELECT statement:

SELECT DATEDIFF (Day, ' 2008-12-29 ', ' 2008-12-30 ') as Diffdate

Results:

Diffdate
1

Example 2

Use the following SELECT statement:

SELECT DATEDIFF (Day, ' 2008-12-30 ', ' 2008-12-29 ') as Diffdate

Results:

Diffdate
-1

SQL Server Date function