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)