How display names of part date in your language?
Sometimes You display name of part of date example: name of day, name of day of week, month.
I show You how change language in SQL Server to display data in Your language. The T-SQL has procedure sys.syslanguages
which display all data for all received languages.
SELECT dateformat, name, alias FROM sys.syslanguages ;
Through @@LANGUAGE
variable You may check current language.
SELECT @@LANGUAGE as language ;
It returns name of language.
In the following examples is select name of weekday and number of weekday depand on current language in SQL Server – counting is depand on country(sometimes the Moday is first day, sametimes Sunday is first day). The first example select data for default language.
SELECT DATENAME( weekday, SYSDATETIME() ) as cdayname , DATEPART( weekday, SYSDATETIME() ) ;
SET LANGUAGE Polish; SELECT DATENAME( weekday, SYSDATETIME() ) as [day in Polish] , DATEPART( weekday, SYSDATETIME() ) ;
SET LANGUAGE Japanese; SELECT DATENAME( weekday, SYSDATETIME() ) as [day in Japanese] , DATEPART( weekday, SYSDATETIME() ) ;
SET LANGUAGE Spanish; SELECT DATENAME( weekday, SYSDATETIME() ) as [day in Spanish] , DATEPART( weekday, SYSDATETIME() ) ;
SET LANGUAGE Czech; SELECT DATENAME( weekday, SYSDATETIME() ) as [day in Czech] , DATEPART( weekday, SYSDATETIME() ) ;
SET LANGUAGE Hungarian; SELECT DATENAME( weekday, SYSDATETIME() ) as [day in Hungarian] , DATEPART( weekday, SYSDATETIME() ) ;
SET LANGUAGE 'Traditional Chinese'; SELECT DATENAME( weekday, SYSDATETIME() ) as [day in Traditional Chinese] , DATEPART( weekday, SYSDATETIME() ) ;