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
|
1 |
SELECT DATEPART(quarter, GETDATE()) AS Quarter_From_Date |
To get the quarter from a different date
|
1 2 3 4 5 |
DECLARE @DateToCheck DATETIME SET @DateToCheck = '7/1/2014' SELECT DATEPART(quarter, @DateToCheck) AS Quarter_From_Date |