Peter Nordberg
asked on
Conversion to month name always in English
Hi,
I have a query looking like this:
This renders the following result:
But say that I would like to have the month name in Swedish instead. That would then be rendered as "Oktober, 2013".
Is this possible to alter?
Peter
I have a query looking like this:
SELECT DATENAME(month, GETDATE()) + ', ' + CONVERT(NVARCHAR(4),year(GETDATE()),121) AS 'Month Name'
This renders the following result:
October, 2013
But say that I would like to have the month name in Swedish instead. That would then be rendered as "Oktober, 2013".
Is this possible to alter?
Peter
are you able to use 'set language' so all is in Swedish? or is it just the month names and other things must stay in English?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, and thanks for answer,
That worked fine!
Peter
That worked fine!
Peter