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

(1 行処理されました)