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
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