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

posted on 2009-02-19 17:31  大斌锅  阅读(112)  评论(0)    收藏  举报