SQL 查询当天,本月,本周的记录_weixin_30293135的博客

SELECT * FROM 表 WHERE CONVERT(Nvarchar, dateandtime, 111) = CONVERT(Nvarchar, GETDATE(), 111) ORDER BY dateandtime DESCSELECT * FROM 表 WHERE CONVERT(Nvarchar