比较日期的方法
select * from 表名 where datediff(d,字段名,日期参数)>0
例:
select * from tblintake where datediff(d,Expiredate,getdate())>0 or Expiredate is null
Expiredate为datetime类型,可能为NULL
select * from 表名 where datediff(d,字段名,日期参数)>0
例:
select * from tblintake where datediff(d,Expiredate,getdate())>0 or Expiredate is null
Expiredate为datetime类型,可能为NULL