Execute the following script in Query Editor to demonstrate the use of the DATENAME function:

USE AdventureWorks;

SET DATEFORMAT mdy
SELECT PC.Name AS ProdCat, PS.Name AS SubCat,
DATEPART(yy, SOH.OrderDate) AS OrderYear, 'Q' +
DATENAME(qq, SOH.OrderDate) AS OrderQtr,
'$'+convert(varchar,SUM(SOD.UnitPrice * SOD.OrderQty),1) AS SalesRev
FROM Production.ProductSubcategory PS
INNER JOIN Sales.SalesOrderHeader SOH
INNER JOIN Sales.SalesOrderDetail SOD
ON SOH.SalesOrderID = SOD.SalesOrderID
INNER JOIN Production.Product P
ON SOD.ProductID = P.ProductID
ON PS.ProductSubcategoryID = P.ProductSubcategoryID
INNER JOIN Production.ProductCategory PC
ON PS.ProductCategoryID = PC.ProductCategoryID
WHERE (SOH.OrderDate BETWEEN '2/1/2002' AND '2/28/2003')
GROUP BY DATEPART(yy, SOH.OrderDate), PC.Name, PS.Name,
'Q' + DATENAME(qq, SOH.OrderDate), PS.ProductSubcategoryID
ORDER BY ProdCat, SubCat, OrderYear, OrderQtr

GO