Returns the time difference between the two dates in the SQL statement. Convert the time difference to the number of days format [reserve by yourself].

Document directory

• Syntax
• Example 1
• Example 2

SQL Server datediff () function definition and usage

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

Syntax

DATEDIFF(datepart,startdate,enddate)

StartdateAndEnddateA parameter is a valid date expression.

DatepartParameters can be the following values:

Datepart	Abbreviations
Year	YY, yyyy
Quarter	QQ, Q
Month	Mm, m
Day of the year	Dy, y
Day	DD, d
Week	Wk, WW
Week	DW, W
Hours	HH
Minutes	Mi, n
Seconds	SS, S
Millisecond	MS
Subtle	MCS
Nanoseconds	NS

Example 1

Use the following SELECT statement:

SELECT DATEDIFF(day,'2008-12-29','2008-12-30') AS DiffDate

Result:

Diffdate
1

Example 2

Use the following SELECT statement:

SELECT DATEDIFF(day,'2008-12-30','2008-12-29') AS DiffDate

Result:

Diffdate
-1