이전 2016 >/DATABASE
[MSSQL] char 형 초단위를 시분초로 변환
망이방
2014. 12. 10. 17:59
declare @ss int
set @ss = 3600
select convert (varchar, dateadd (s, @ss, '' ), 8) as '재생시간'
재생시간
===============
01:00:00
적용 예>
select
(select convert (varchar, dateadd (s, duration, '' ), 8)) as '러닝타임'
, duration
from movie
===============
러닝타임 duration
| 01:08:09 |
4089 |
| 01:05:38 | 3938 |
| 00:48:49 | 2929 |
| 00:47:32 | 2852 |
| 01:01:32 | 3692 |
| 01:05:38 | 3938 |
| 01:25:11 | 5111 |
| 01:03:00 | 3780 |
| 01:27:59 | 5279 |
| 00:00:00 | 0 |