导进数据库再处理呗,比如
DECLARE @a VARCHAR(30)
SET @a='20130101121212'
SELECT LEFT(@a,4)+'-'+SUBSTRING(@a,5,2)+'-'+SUBSTRING(@a,7,2)+' '+SUBSTRING(@a,9,2)+':'+SUBSTRING(@a,11,2)+':'+SUBSTRING(@a,13,2)+'.000'
/*
-------------------------------------
2013-01-01 12:12:12.000
*/
DECLARE @a VARCHAR(30)
SET @a='20130101121212'
SELECT LEFT(@a,4)+'-'+SUBSTRING(@a,5,2)+'-'+SUBSTRING(@a,7,2)+' '+SUBSTRING(@a,9,2)+':'+SUBSTRING(@a,11,2)+':'+SUBSTRING(@a,13,2)+'.000'
/*
-------------------------------------
2013-01-01 12:12:12.000
*/
set 字段 = LEFT(文本字段,8)+' '+SUBSTRING(文本字段,9,2)+':'+SUBSTRING(文本字段,11,2)+':'+SUBSTRING(文本字段,13,2)