数字转换成英文日期
我想把01,02,03这类数字转换成jan，feb，mar这类
请问有什么简便的方法吗?

[解决办法]
replace
[解决办法]

SQL code

set language englishselect convert(varchar(3),dateadd(m,number,'2011-01-01'),7) from master..spt_values where type='p' and number<12/*----JanFebMarAprMayJunJulAugSepOctNovDec(12 行受影响)*/
[解决办法]
SQL code
declare @language sysnameset @language=@@LANGUAGEset language english    select dateNAME(MONTH,dateadd(m,number,'2011-01-01'))    from master..spt_values where type='p' and number<12set language @language/*Changed language setting to us_english.------------------------------JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember(12 行受影响)已将语言设置更改为 简体中文。*/
[解决办法]
探讨


SQL code
set language english
select convert(varchar(3),dateadd(m,number,'2011-01-01'),7) from master..spt_values where type='p' and number<12
/*
----
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec……