declare @sec int set @sec=130210 select convert(varchar(5),@sec/3600)+' Hrs : '+convert(varchar(5),@sec%3600/60)+' Min : '+convert(varchar(5),(@sec%60))+' Sec' OR --If 130210 is Second : SELECT CONVERT(varchar(8), DATEADD(second, 130210 , '0:00:00'), 108) --If 130210 is Minute : SELECT convert (varchar(8),dateadd(minute,130210 ,'0:00:00'),108) OR declare @Diff int set @Diff=130210 SELECT CONVERT(varchar(6), @Diff/3600) + ':' + RIGHT('0' + CONVERT(varchar(2), (@Diff % 3600) / 60), 2) + ':' + RIGHT('0' + CONVERT(varchar(2), @Diff % 60), 2)
Never Think That You Have Failed Instead Always Think That u hav Better Chance Next Time...