在MS SQL中如何获取本周、本月、本季度的记录…，这一切，都与日期时间函数相关，下面我们就来学习这方面的知识。
前提条件：假设表名为：tableName；时间字段名为：theDate
①查询本周的记录
select * from tableName where DATEPART(wk, theDate) = DATEPART(wk, GETDATE()) and DATEPART(yy, theDate) = DATEPART(yy, GETDATE())
②查询本月的记录
select * from tableName where DATEPART(mm, theDate) = DATEPART(mm, GETDATE()) and DATEPART(yy, theDate) = DATEPART(yy, GETDATE())
③查询本季的记录
select * from tableName where DATEPART(qq, theDate) = DATEPART(qq, GETDATE()) and DATEPART(yy, theDate) = DATEPART(yy, GETDATE())
select datediff(day,dateadd(mm, datediff(mm,'''',getdate()), ''''),dateadd(mm, datediff(mm,'''',getdate()), ''1900-02-01''))
④查询本月记录的通用语句
SELECT * FROM [表名] WHERE (DATEPART(mm, 日期) = @month) AND (DATEPART(yy, 日期) = @year)