--以下示例演示了在不同的語言環(huán)境(SET LANGUAGE)下，DATENAME與CONVERT函數(shù)的不同結(jié)果。
USE master

--設(shè)置會(huì)話的語言環(huán)境為: English
SET LANGUAGE N'English'
SELECT 
	DATENAME(Month,GETDATE()) AS [Month],
	DATENAME(Weekday,GETDATE()) AS [Weekday],
	CONVERT(varchar,GETDATE(),109) AS [CONVERT]
/*--結(jié)果:
Month    Weekday   CONVERT
------------- -------------- -------------------------------
March    Tuesday   Mar 15 2005  8:59PM
--*/

--設(shè)置會(huì)話的語言環(huán)境為: 簡(jiǎn)體中文
SET LANGUAGE N'簡(jiǎn)體中文'
SELECT 
	DATENAME(Month,GETDATE()) AS [Month],
	DATENAME(Weekday,GETDATE()) AS [Weekday],
	CONVERT(varchar,GETDATE(),109) AS [CONVERT]
/*--結(jié)果
Month    Weekday    CONVERT
------------- --------------- -----------------------------------------
05       星期四     05 19 2005  2:49:20:607PM
--*/