摘要: select * from ShopOrder where datediff(day,ordTime,getdate()-1)=0 --查询当天(2:select * from info where DateDiff(dd,datetime,getdate())=0 --前30天 SELECT * 阅读全文
posted @ 2016-07-18 10:12 刘小轩 阅读(32522) 评论(0) 推荐(0) 编辑