hi friends,
                I have a Date.. i want to find the difference between that date & current date in days:hrs:min:sec format.. i'm a newbie to sql server..pls help me in this regard..
 thanks
 anandham

Prem Anandh P.
Ambition Never comes to an End

__________________
Prem Anandh P.
Ambition Never comes to an End

declare @startDate datetime
set @startDate = '03/12/2005 12:00:00'

declare @endDate datetime
set @endDate = '03/18/2005 12:00:00'

declare @result integer
SELECT @result= DATEDIFF( second, @startDate , @endDate )

select convert(varchar(5), @result/86400)+':'+convert(varchar(5),(@Result%86400/3600))+':'+convert(varchar(5),@Result%3600/60)+':'+convert(varchar(5),(@Result%60))

 hi shahchi1,
          thank u very much for the very useful code..
          It works fine..i have implemented that in my
          application..thax again for ur valuable help
 Thanks & Regards,
 anandham





Prem Anandh P.
Ambition Never comes to an End