将秒数显示为小时分钟数

select PAYCODENAME
	,APPLYDATE
	,TIMEINSECONDS
	,RIGHT('00'+ CAST(TIMEINSECONDS/3600 AS VARCHAR), 2)
	+':'+RIGHT('00'+ CAST(TIMEINSECONDS%3600/60 AS VARCHAR), 2) CLOCK
from VP_TOTALS
where PERSONNUM ='20000000105';