Get Time Difference between Two Dates and Datediff() Function to Show Date Difference in Days Hours Minutes in SQL Server

Hi friends,
In this article I will explain how to get time difference between two dates in SQL server.

DECLARE @Sdate DATETIME, @Edate DATETIME, @Timedifference VARCHAR(100)

SELECT @Sdate = '02/12/2014 08:40:18.000',@Edate='02/13/2014 09:52:48.000'

SET @Timedifference=DATEDIFF(s, @Sdate, @Edate)

SELECT CONVERT(VARCHAR(5),@Timedifference/3600)+':'+convert(varchar(5),@Timedifference%3600/60)+':'+convert(varchar(5),@Timedifference%60) AS Time_Difference

Once we run above query we will get output like as shown below

 Output

Now  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

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

Out Put

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

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

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

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

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