2.8w+
社区成员
- 主页
...全文
请发表友善的回复…
发表回复
Jaron 2004-04-06
SELECT * FROM shop where shdate <= DATEADD(day, -7, getdate())
如果是 Access ,将 getdate() 换为 now()
如果是 Access ,将 getdate() 换为 now()
swordman123 2004-04-06
sql="select * from shop where datediff("d",now(),shdate)>7 "
swordman123 2004-04-05
sql="select * from shop where datediff("d",now(),time)>7 "