sqlserver查询一个月内的数据 SELECT * FROM dbo.ManageManage_Purchase WHERE DATEDIFF(dd, CreateTime , GETDATE()) <= 30 -- 30天内