see this code once
DECLARE @fromDate datetime2 ='2012-10-27 13:05:00'
SELECT DATEDIFF(DD, @fromDate, GETDATE()) DaysDiff
SELECT DATEDIFF( hh, @fromDate, GETDATE()) HoursDiff, DATEDIFF( MI, @fromDate, GETDATE()) MinutesDiff, DATEDIFF( hh, @fromDate, GETDATE())/24 DaysDiff
SELECT convert(varchar(5),datediff(HOUR ,@fromdate,GETDATE())) + ' hour '+
convert(Varchar(5),DATEDIFF (Minute,@fromDate,GETDATE())%60) +' Minute ' +
convert(Varchar(5),DATEDIFF (SECOND ,@fromDate,GETDATE())%60) +' Second '
--
Chandu
get time difference
Posted - 11/27/2012 : 02:39:38
