How To Find All Months Of a Particular Quarter In SQL Server

In this blog, you will learn how you can find all the months of a particular quarter.

The code is given below with which we get the list of months between a particular quarter.

 

Script

DECLARE @AnyDate DATETIME
SET @AnyDate = GETDATE()

DECLARE @StartDate  DATETIME,
        @EndDate    DATETIME;
 select @StartDate = DATEADD(q, DATEDIFF(q, 0, @AnyDate), 0)

  select @EndDate   = DATEADD(d, -1, DATEADD(q, DATEDIFF(q, 0, @AnyDate) + 1, 0));


SELECT  DATENAME(MONTH, DATEADD(MONTH, x.number, @StartDate)) AS MonthName
FROM    master.dbo.spt_values x
WHERE   x.type = 'P'
AND     x.number <= DATEDIFF(MONTH, @StartDate, @EndDate);

Output

 

 

Thanks.