Easy Tutorial
Sql Having Sql Func Mid Sql Between Sql Drop Sql Wildcards Sql Join Inner Sql Join Full Sql Func Lcase Sql Where Sql Join Sql Func Round Sql Primarykey Sql Func First Sql Func Len Sql Distinct Sql Func Ucase Sql Function Sql Delete Sql Autoincrement Func Curtime Sql Update Sql Isnull Func Date Sub Sql Constraints Sql Intro Sql Dates Sql Select Into Sql Hosting Sql Create Table Sql Func Format Sql View Sql Func Count Sql Index Sql Like Sql Datatypes General Sql Datatypes Func Convert Sql Func Avg Sql Foreignkey Sql Func Sum Sql Join Right Func Curdate Sql Alias Sql Union Func Date Add Sql Groupby Sql Summary Sql In Sql Null Values Sql Syntax Sql Tutorial Sql Insert Into Select Sql And Or Sql Join Left Sql Func Now Func Date Sql Top Index Sql Create Db Sql Unique Sql Check Func Extract Sql Alter Sql Notnull Func Now Sql Select Sql Insert Sql Func Max Sql Exists Sql Func Min Func Date Format Func Datediff Mysql Func Getdate Sql Orderby Func Datediff Sql Func Last Sql Create Index Func Dateadd Sql Quickref Func Datepart
❮ Sql Orderby Sql Func Last ❯

SQL Server DATEDIFF() Function

Definition and Usage

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

Syntax

The startdate and enddate parameters are valid date expressions. The datepart parameter can be one of the following values:

datepart Abbreviation
Year yy, yyyy
Quarter qq, q
Month mm, m
Day of Year dy, y
Day dd, d
Week wk, ww
Weekday dw, w
Hour hh
Minute mi, n
Second ss, s
Millisecond ms
Microsecond mcs
Nanosecond ns

Example

Now we want to get the number of days between two dates.

We use the following SELECT statement:

Result:

DiffDate
61

Example

Now we want to get the number of days between two dates (note that the second date is earlier than the first, resulting in a negative number).

We use the following SELECT statement:

Result:

DiffDate
-61
❮ Sql Orderby Sql Func Last ❯