select datediff(d,
( select isnull( ( select v.VerifyDate from T_VerifySituation v where OrderId = 19116 and v.VerifyStatus= 1008 ),getdate()))
,
(select v.VerifyDate from T_VerifySituation v where OrderId = 19116 and v.VerifyStatus= 3024)
)
sql 时间向减函数
原文：http://www.cnblogs.com/dullbaby/p/5091987.html
