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';
将秒数显示为小时分钟数
最新推荐文章于 2022-08-12 17:22:05 发布