"sql server get the full month name from a date" Code Answer

1
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]
By Rudi on June 2 2022

Answers related to “sql server get the full month name from a date”

Only authorized users can answer the Search term. Please sign in first, or register a free account.