thanks pallini,
DATEDIFF (datepart ,startdate ,enddate )
but the startdate and enddate are contained as column value and i have to calculate the time difference in each row.
i have a query:
DECLARE @INT INT
SET @INT = DATEDIFF(SECOND,GETDATE(),GETDATE()+1)
select
convert(varchar(10), (@INT/86400)) + ':' +
convert(varchar(10), ((@INT%86400)/3600)) + ':'+
convert(varchar(10), (((@INT%86400)%3600)/60)) + ':'+
convert(varchar(10), (((@INT%86400)%3600)%60)) as 'DD:HH:MM:SS'
how can i add the value of colums so that it could display me the time difference of complete table.
thanks