摘要： declare @str varchar(14) set @str='20080210182031' select cast(left(@str,8) as datetime)+stuff(stuff(right(@str,6),3,0,':'),6,0,':') 输出结果 2008-02-10 18:20:31.000 阅读全文