case when datediff(day,字段,getdate())<=0 then 0 else datediff(day,字段,getdate()) end
應該反過來 select case when datediff(day,getdate(),日期)<=0 then 0 else datediff(day,getdate(),日期) end from tb如下: select case when datediff(day,getdate(),'2004-09-18')<=0 then 0 else datediff(day,getdate(),'2004-09-18') end from tb 結果:0
select
case when datediff(day,getdate(),日期)<=0 then 0 else datediff(day,getdate(),日期) end
from tb如下:
select
case when datediff(day,getdate(),'2004-09-18')<=0 then 0 else datediff(day,getdate(),'2004-09-18') end
from tb
結果:0