SQL Sever Datediff() Function to Show Date Difference in Days Hours Minutes

Introduction:

Here I will explain datediff() function in SQL Server with example to get date difference in days hours minutes, years, month between two dates or calculate datediff in SQL Server in days hours minutes format.

Datediff() function

This function is used to get time difference between two dates like days, hours, minutes, seconds, years, months. Generally Datediff function will take 3 arguments.

Declaration of SubString function

DATEDIFF(DATEPART, startdate, enddate)

In this function startdate and enddate will be valid dates and Datepart will be one of the following like as shown below

Datepart	Datepart (Another way declaration)
year	yy, yyyy
quarter	qq, q
month	mm, m
week	wk, ww
day	dd, d
hour	hh
minute	mi, n
second	ss, s

Examples of Datediff Function:

EX1:

SELECT DATEDIFF(hh,GETDATE()-1,GETDATE()) AS DateDifference

Output:

24

In above query we declared datepart as hh that’s why that return hours difference between two dates

EX2:

SELECT DATEDIFF(day,'2014-02-12',GETDATE()) AS DateDifference

Output:

365

In above query we declared datepart as day that’s why that return days difference between two dates

EX3:

SELECT DATEDIFF(ww,'2014-03-12',GETDATE()) AS DateDifference

Output:

52

In above query we declared datepart as week that’s why that return weeks difference between two dates