declare@dayint
declare@hourint
declare@minint
declare@secint
declare@allsint
set@alls=datediff(s,'2009-11-2100:00:00','2009-11-2415:12:24')
set@day=@alls/86400
set@hour=(@alls-@day*86400)/3600
set@min=(@alls-@day*86400-@hour*3600)/60
set@sec=@alls-@day*86400-@hour*3600-@min*60
selectCAST(@dayasvarchar(5))+'天'+CAST(@hourasvarchar(2))+'小时'+CAST(@minasvarchar(2))+'分'+CAST(@secasvarchar(2))+'秒'