mssql 获取2个时间之间相距的时分秒（取余数得秒）

小时，分钟 和网上大多数的一样

秒则不同，2个时间差（单位秒）然后除以60取余数，就是相差的秒

select t1.C_WORKDATE
,t1.C_REQUEST_TYPE
,t1.C_STATE
,t1.C_REQUEST_TIME
,t2.C_USER_NAME
,t1.C_EXECUTE_TIME
,t1.C_MAINTAIN_TIME
,t1.C_FREE_TIME
,cast(floor((datediff(ss,t1.C_REQUEST_TIME,t1.C_FREE_TIME) )/(60*60)) as varchar) as TakeHour
,cast( (floor((datediff(ss,t1.C_REQUEST_TIME,t1.C_FREE_TIME) )-(datediff(ss,t1.C_REQUEST_TIME,t1.C_FREE_TIME) )/(3600)*3600) /60) as varchar) as TakeMinute
,cast( ( floor(datediff(ss,t1.C_REQUEST_TIME,t1.C_FREE_TIME)%60) ) as varchar) as TakeSecond
from T_SC_REQUEST t1

转载于:https://www.cnblogs.com/xjiangblog/p/8204880.html