Display monthname in other language

Question

In my view, I want to display the MonthName in German. How can I change the monthname from English to German. DATENAME(month, getdate()) AS 'MonthName'

Answer 1

try:

see languages,

by SELECT * FROM sys.syslanguages

SET LANGUAGE Spanish
SELECT DATENAME(MONTH, GETDATE()) AS 'MonthName'

SET LANGUAGE German
SELECT DATENAME(MONTH, GETDATE()) AS 'MonthName'

SET LANGUAGE us_english
SELECT DATENAME(MONTH, GETDATE()) AS 'MonthName'