





One question that we get a lot is how to get the quarter from a date. SQL Server has a very easy way to get the quarter from a date (since SQL 2005) using the DATEPART command.
To get the quarter from the current date
SELECT DATEPART(quarter, GETDATE()) AS Quarter_From_Date
To get the quarter from a different date
DECLARE @DateToCheck DATETIME SET @DateToCheck = '7/1/2014' SELECT DATEPART(quarter, @DateToCheck) AS Quarter_From_Date