qq_29020537的博客

注：谢绝任何形式的转载和抄袭 sqlserver毫秒转时分秒，不格式化： -- t.workTime为工作时长，单位是毫秒-- 显示样式：0:0:8, 0:1:10, 2:30:5SELECT t.*,CAST(t.workTime/1000/60/60 AS VARCHAR(10))+':'+CAST(t.workTime%(1000*60*60)/1000/60 AS VARCHAR(2))+':'+CAST(t.workTime%(1000*60*60)%(1000*60)/.