如何将日期格式转换为英文格式

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