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

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

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

 

SELECT DATEDIFF(day,'2013-02-07',GETDATE()) AS DateDifference 

 

SELECT DATEDIFF(ww,'2013-02-07',GETDATE()) AS DateDifference