数字转换成英文日期,该怎么解决_Sql Server

数字转换成英文日期
我想把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 codedeclare @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……