cast ( cast ( datediff ( ss, starttime, concludetime ) / ( 60 * 60 * 24 ) as int ) as varchar ) + '天' + cast ( cast ( datediff ( ss, starttime, concludetime ) % 86400 / 3600 as int ) as varchar ) + '小时' + cast ( cast ( datediff ( ss, starttime, concludetime ) % 3600 / 60 as int ) as varchar ) + '分' + cast ( cast ( datediff ( ss, starttime, concludetime ) % 60 as int ) as varchar ) + '秒' lengthoftime