초를 시:분:초로 변환 > db

12265초=>3:24:34
이렇게 시:분:초로 변환하고싶습니다

====================================================================================

declare @sec int
set @sec = 12274

select @sec/3600 as hh, (@sec%3600)/60 as mm, (@sec%3600)%60 as ss

hh          mm          ss
----------- ----------- -----------
3           24          34

(1개 행 적용됨)

--또는

select cast(@sec/3600 as varchar) + ':' +
       right('0'+cast((@sec%3600)/60 as varchar(2)),2) + ':' +
       right('0'+cast((@sec%3600)%60 as varchar(2)),2)

--------------------------------------
3:24:34

(1개 행 적용됨)