SET NOCOUNT ON
-- 如2006-08-24要显示成Aug 24, 2006
SET LANGUAGE 'English'
SELECT GETDATE(),CONVERT(VARCHAR,GETDATE(),107)
-- 2006-08-24 10:20:31.810 Aug 24, 2006
-- 如2006-08-24要显示成August 24, 2006
SET LANGUAGE 'English'
SELECT GETDATE(),DATENAME(mm, GETDATE()) + RIGHT(CONVERT(varchar, GETDATE(), 107), 9)
-- 2006-08-24 10:20:31.810 August 24, 2006
-- 改回中文
SET LANGUAGE 'Simplified Chinese'
SET NOCOUNT OFF