22,199
社区成员
发帖
与我相关
我的任务
分享
SET LANGUAGE us_english
SELECT CONVERT(DATETIME,'Jan 15 2014 12:26:00:000PM ',109)
DECLARE @a VARCHAR(50)
SET @a='Jan 15 2014 12:26:00:000PM'
SET LANGUAGE us_english
SELECT DATENAME(year, @a)+'-'+CASE DATENAME(month, @a)WHEN 'January' THEN '01'
WHEN 'February' THEN '02' WHEN 'March' THEN '03' WHEN 'April' THEN '04' WHEN 'May' THEN '05'
WHEN 'June' THEN '06' WHEN 'July' THEN '07' WHEN 'August' THEN '08' WHEN 'September' THEN '09'
WHEN 'October' THEN '10' WHEN 'November' THEN '11' ELSE '12' END
+'-'+DATENAME(day, @a)+' '+DATENAME(hour, @a)+':'+DATENAME(MINUTE, @a)+':'+RIGHT('00'+DATENAME(second, @a),2)
/*
---------------------------------------------------------------------------------------------------------------------------------
2014-01-15 12:26:00
*/
DECLARE @a VARCHAR(50)
SET @a='Feb 15 2014 12:26:00:000PM'
select CONVERT(DATETIME,stuff(stuff(stuff(@a,4,1,'-'),7,1,'-'),1,3,
ceiling(charindex(substring(@a,1,3),'JanFebMarAprMayJunJulAugSepOctNovDec')/3.0)))