sqlserver 时间间隔

select top 10000 
datediff(ss, startdate, finishdate) / (3600 * 24) as 天,
datediff(ss, startdate, finishdate) / 3600 % 24 as 小时,
datediff(ss, startdate, finishdate) / 60 % 60 as 分,
datediff(ss, startdate, finishdate) % 60 as 秒 from test1