CODEWITHSUNDEEP
sqlsql-serverdatetime
user3453159
user3453159

Reputation: 159

Show name of Month

This is my output

enter image description here

select name as product, avg(OrderQty) as average, OrderDate
from Production.Product
join Sales.SalesOrderDetail on SalesOrderDetail.ProductID = Product.ProductID
join Sales.SalesOrderHeader on SalesOrderHeader.SalesOrderID = SalesOrderDetail.SalesOrderID
where OrderDate like '%2011%'
group by Name, OrderDate

I want to change order Date to the month for example

2011-10-24 00.00.00.000 ==> october

Upvotes: 0

Views: 49

Answers (1)

zealous
zealous

Reputation: 7503

You can use datename() in SQL Server to get name of the month.

select 
   datename(month, orderDate) AS monthName
from yourTable

Upvotes: 4

Related Questions