sql server 2008 - sql time from value -

i have column integer values in seconds, ie:

seconds 234555 1123 44567 

i need select of column return value should in form of 1d 13h 23m

how should formulate sql query?

not solution anyways

declare @day int declare @tmphour int declare @hour int declare @tmpminute int declare @min int  select @day = seconds_column/ (24*60*60),@tmphour = seconds_column%(24*60*60) yourtable  select @hour = @tmphour / (60*60) select @tmpminute = @tmphour%(60*60) select @min = @tmpminute/60  select cast(@day varchar) + ' day '+         cast(@hour varchar) + ' hour ' +         cast(@min  varchar) + ' min'