摘要:
select * from 表名 where datediff(d,字段名,日期参数)>0 例: select * from tblintake where datediff(d,Expiredate,getdate())>0 or Expiredate is null Expiredate为datetime类型,可能为NULL 阅读全文
摘要:
SELECT 32-DAY(getdate()+32-DAY(getdate()))select day(dateadd(mm,1,getdate())-day(getdate())) 阅读全文
摘要:
代码 阅读全文