Returning Month Name in SQL Server Query

Convert Month Number to Month Name Function in SQL

A little hacky but should work:

SELECT DATENAME(month, DATEADD(month, @mydate-1, CAST('2008-01-01' AS datetime)))

Returning Month Name in SQL Server Query

This will give you the full name of the month.

select datename(month, S0.OrderDateTime)

If you only want the first three letters you can use this

select convert(char(3), S0.OrderDateTime, 0)

SQL Server : month name from date column

Try below query

SELECT DATENAME (MONTH, DATEADD(MONTH, MONTH(Txndate) - 1, '1900-01-01')) MonthName

Or
SELECT FORMAT(g.Txndate, 'MMMM') AS Result

Reference

SQL Server : query to return month name instead of number

Instead of Month function use Datename function with Month datepart

select  datename(month,date) [month]
       ,isnull(sum(case when year(DATE) = 2015 then sales end), 0) as '2015'
from tblSales
where tenantcode = 'cmbina13'
group by  datename(month,date)
Order by DATEPART(MM,datename(month,date)+' 01 2011')

How to return month short form from date in SQL Server?

Assuming you're using SQL Server, you can use the SUBSTRING function, i.e.

SELECT SUBSTRING(DATENAME(month, GETDATE()), 1, 3) AS 'Month Name'

Get month name from SQL Server date value in table column

You should try something like this

select convert(char(3), [date], 0)
select datename(month, [date])

Month name from date in SQL Server

try this...

SELECT DATENAME(month, getdate()) AS [Month Name]

SQL Query to retrieve month name from database

try this

SELECT DATENAME(month, Invoice_Date), SUM(R.Total) AS TOTAL
FROM Sales R
GROUP BY DATENAME(month, Invoice_Date)
ORDER BY DATENAME(month, Invoice_Date);

sql server Get the FULL month name from a date

SELECT DATENAME(MONTH, GETDATE()) 
         + RIGHT(CONVERT(VARCHAR(12), GETDATE(), 107), 9) AS [Month DD, YYYY]

OR Date without Comma Between date and year, you can use the following

SELECT DATENAME(MONTH, GETDATE()) + ' ' + CAST(DAY(GETDATE()) AS VARCHAR(2))
           + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [Month DD YYYY]

---

Related Topics