How to get the quarter of the year from a date parameter

Declare @AsOfDate Date='04/30/2013'

Select Cast(((MONTH(@AsOfDate)-1)/3) as int)+1 as Quarter
--or
SELECT DATENAME(quarter, @AsOfDate)

Related Posts

Comments are closed.