<pre name="code" class="sql">-- datediff( day, '比较时间', GETDATE() )
DECLARE @ctime INT
SELECT @ctime = datediff( day, (SELECT MAX(InDate) FROM OrderSettlement), GETDATE() )
IF @ctime > 0
BEGIN
-- 时差大于1天
END
<pre name="code" class="sql">-- datediff( day, '比较时间', GETDATE() )
DECLARE @ctime INT
SELECT @ctime = datediff( day, (SELECT MAX(InDate) FROM OrderSettlement), GETDATE() )
IF @ctime > 0
BEGIN
-- 时差大于1天
END