sql日期显示为英文缩写月份加号数

SET LANGUAGE US_ENGLISH
SELECT GETDATE() AS NowTime,REPLACE(ISNULL(LEFT(CONVERT(VARCHAR(30),GETDATE(),7),6),''),' ','') AS NewTime

 

----------------------------------------------------------------------

Changed language setting to us_english.
NowTime                 NewTime
----------------------- ----------------------------------------------
2009-06-16 11:42:12.847 Jun16

 

另外一个格式（包括年份）：

Cast(REPLACE(ISNULL(LEFT(CONVERT(VARCHAR(30),@odatetime,107),20),''),' ','') as nvarchar)

转载于:https://www.cnblogs.com/silverLee/archive/2009/12/09/1620165.html