反正只有12个月 写一下case when 好了 select case when left(time,charindex(time,'-')-1)='Jan' then '01' when...........................---中间从2月写到12月 end+ltrim(right(time,len(time)-charindex(time,'-'))) from tb
set language us_english select cast(replace('Jan-26-1','-',' ') as datetime) /*----------------------- 2001-01-26 00:00:00.000 */ set language 简体中文
------------------------------------------------------
2010-01-26 00:00:00.000(所影响的行数为 1 行)
**/
写一下case when 好了
select
case when left(time,charindex(time,'-')-1)='Jan' then '01'
when...........................---中间从2月写到12月
end+ltrim(right(time,len(time)-charindex(time,'-')))
from
tb
select cast(replace('Jan-26-1','-',' ') as datetime)
/*-----------------------
2001-01-26 00:00:00.000
*/
set language 简体中文