SET LANGUAGE us_english select left(DATENAME(dw,convert(datetime,'2010-3-24')),3) +' '+DATENAME(dd,convert(datetime,'2010-3-24')) +' '+left(DATENAME(mm,convert(datetime,'2010-3-24')),3) +' '+DATENAME(yyyy,convert(datetime,'2010-3-24')) Changed language setting to us_english.
--------------------------------------------------------------------- Wed 24 Mar 2010(所影响的行数为 1 行)
SET LANGUAGE us_english select left(DATENAME(dw,convert(datetime,'2010-3-24')),3) +' '+DATENAME(dd,convert(datetime,'2010-3-24')) +' '+left(DATENAME(mm,convert(datetime,'2010-3-24')),3) +' '+DATENAME(yyyy,convert(datetime,'2010-3-24'))
convert(datetime, 'Wed,24 Mar 2010', 101)
感谢各位,我用拼接的.看起来好复杂,因为中间还有日期相加,不过效果达到了 CAST(left(DATENAME(dw,convert(datetime,dateadd(day,cast(Maturity as int),GETDATE()))),3) as varchar)+','+convert(varchar,dateadd(day,cast(Maturity as int),GETDATE()),106)
SET LANGUAGE us_english
select left(DATENAME(dw,convert(datetime,'2010-3-24')),3)
+' '+DATENAME(dd,convert(datetime,'2010-3-24'))
+' '+left(DATENAME(mm,convert(datetime,'2010-3-24')),3)
+' '+DATENAME(yyyy,convert(datetime,'2010-3-24'))
Changed language setting to us_english.
---------------------------------------------------------------------
Wed 24 Mar 2010(所影响的行数为 1 行)
select left(DATENAME(dw,convert(datetime,'2010-3-24')),3)
+' '+DATENAME(dd,convert(datetime,'2010-3-24'))
+' '+left(DATENAME(mm,convert(datetime,'2010-3-24')),3)
+' '+DATENAME(yyyy,convert(datetime,'2010-3-24'))
CAST(left(DATENAME(dw,convert(datetime,dateadd(day,cast(Maturity as int),GETDATE()))),3) as varchar)+','+convert(varchar,dateadd(day,cast(Maturity as int),GETDATE()),106)