sqlserver查询一个月内的数据

SELECT * FROM dbo.ManageManage_Purchase WHERE DATEDIFF(dd, CreateTime  , GETDATE()) <= 30 -- 30天内

原文地址:https://www.cnblogs.com/jiamengyang/p/9300654.html