原文地址:http://blog.sina.com.cn/s/blog_93dccc950101l3z9.html
--查询当天(1:
select * from ShopOrder where datediff(day,ordTime,getdate()-1)=0
--查询当天(2:
select * from info where DateDiff(dd,datetime,getdate())=0
--前30天
SELECT * FROM A where datediff(d,datetime,getdate()) <=30
--上一月
SELECT * FROM A WHERE DATEDIFF(m, shijian, GETDATE()) <=1
--查询24小时内的:
select * from info where DateDiff(hh,datetime,getDate())<=24
--本月记录
SELECT * FROM 表 WHERE datedi......
阅读全文