Sql Server Get The Full Month Name from a 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]

Month name from date in SQL Server

try this...

SELECT DATENAME(month, getdate()) 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])

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)))

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

How to get Month Name and Year from given date?

In SQL Server 2012 and later, ie in all supported versions, you can use FORMAT to format a value using a .NET format string :

select format(getdate(),'MMMM, yyyy')

Returns :

February, 2018

In earlier versions you'd have to concatenate individual names, eg :

SELECT DATENAME(MONTH, GETDATE()) + ', ' + DATENAME(YEAR,GETDATE())

To get :

February, 2018

A better approach though would be to format values on the client, by setting, eg a report or form field's format string. It's easier for the client or the report creator to know the correct format and locale to use to display dates.

You can pass a locale identifier to specify the locale, eg:

select format(getdate(),'MMMM, yyyy','fr-FR')

Will return :

février, 2018

This should only be considered a workaround though.

Month Name and Last date of each month for previous 3 months in sql

You can use SQL Server EOMONTH() function to compute the last day of a month.

Consider:

WITH R(N) AS (
    SELECT 1 UNION ALL SELECT N+1 FROM R WHERE N < 3
)
SELECT 
    LEFT(DATENAME(MONTH,DATEADD(MONTH,-N,GETDATE())),3) AS [month], 
    EOMONTH(GETDATE(), -N) AS [EOM_DATE],
    DATEPART(YEAR,DATEADD(MONTH,-N,GETDATE())) AS [year]
FROM R;

---

Related Topics