sql 日期转换问题 - MS-SQL Server / 疑难问题

Feb 2011 怎么样可以转成2011M02 谢谢~~~急 马上结贴

---

Feb 2011是什么类型

---

VARCHAR

---

SQL code:
set language english
select convert (datetime,'01 '+'Feb 2011',121)


------------------------------------------------------
2011-02-01 00:00:00.000

（所影响的行数为 1 行）

先示一下

---

2011M02???

这样的转换方法..

---

SQL code:

declare @language sysname
set @language=@@language
set language english

select replace(convert(char(7),convert(datetime,'01 Feb 2011'),120),'-','M')

set language @language


Changed language setting to us_english.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2011M02

(1 行受影响)

已将语言设置更改为 简体中文。

---

SQL code:
create function f_getym(@s varchar(20))
returns varchar(20)
as
begin
return
right(@s,4)+'M'+
case left(@s,3)
when 'Jan' then