language

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 ... l Chinese'; SELECT DATENAME( weekday, SYSDATETIME() ) as [day in Traditional Chinese] , DATEPART( weekday, SYSDATETIME() ) ;