Get the quarter of a given date in datetime format

In SQL Server you can get the quarter of a year by using the datepart function. This will return 1/1/year, 4/1/year, 7/1/year or 10/1/year depending on the date you entered.

Sometimes, it is necessary to get the quarter of a given date in datetime format. Here is a simple scalar function how to do it:

CREATE FUNCTION GetQuarter (@date DATETIME)
RETURNS DATETIME
AS
BEGIN
RETURN CONVERT(DATETIME, CONVERT(CHAR(8),
DATEPART(YEAR, @date) * 10000 +
( DATEPART(QUARTER, @date) * 3 - 2) * 100 +
1),
112)
END

Use the function like this:

 
SELECT dbo.GetQuarter(dateColumn) AS Quarter FROM myTable