select case when datediff(day,getdate(),提醒日期)<0 then 0 else datediff(day,getdate(),提醒日期) end from a
select 提醒日期 , case when 剩余天数 < 0 then 0 else 剩余天数 end 剩余天数 from A from tbselect 提醒日期 , case when 提醒日期 < 当天日期 then 0 else datediff(day , 当天日期 , 提醒日期) end 剩余天数 from A from tb
select 提醒日期, case when datediff(day,getdate(),提醒日期)<0 then 0 else datediff(day,getdate(),提醒日期) end from tb
select 提醒日期, case when datediff(day,getdate(),提醒日期)<0 then 0 else datediff(day,getdate(),提醒日期) end as 剩余天数 from tb
from a
case when datediff(day,getdate(),提醒日期)<0
then 0
else datediff(day,getdate(),提醒日期)
end
from tb
select 提醒日期,
case when datediff(day,getdate(),提醒日期)<0
then 0
else datediff(day,getdate(),提醒日期)
end as 剩余天数
from tb