access有没有t-sql中的datediff函数?

用vb+access如何实现:
select * from table where datediff('dd',outdate,getdate())>3

多谢!
---------------------------------------------------------------

select * from table where datediff('d',outdate,now)>3
or
select * from table where dateadd('d',4,outdate)<now();

Published At
Categories with 数据库类
comments powered by Disqus