SQL SERVER 天、周 、月、季、年统计查询

一、SQL SERVER 月、季、年统计查询

--本天

SELECT *FROM dbo.TableName WHERE DATEDIFF(DAY,TimeField,getdate())= 0;

--本周

SELECT *FROM dbo.TableName WHERE DATEDIFF(WEEK,TimeField,getdate())= 0;

--本月

SELECT *FROM dbo.TableName WHERE DATEDIFF(MONTH,TimeField,getdate())= 0;

--本季度

SELECT *FROM dbo.TableName WHERE DATEPART(qq, TimeField) = DATEPART(qq, GETDATE()) and DATEPART(yy, TimeField) = DATEPART(yy, GETDATE());

--上季度

SELECT *FROM dbo.TableName WHERE DATEPART(qq, TimeField) = (DATEPART(qq, GETDATE())-1) and DATEPART(yy, TimeField) = DATEPART(yy, GETDATE());

--本年

SELECT *FROM dbo.TableName where DATEDIFF(YEAR, TimeField,getdate())= 0;