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)