22,207
社区成员
发帖
与我相关
我的任务
分享
declare @date varchar(14)
set @date= '20120827192222'
select(left(@date,4)+'-'+substring(@date,5,2)+'-'+substring(@date,7,2)+' '+substring(@date,9,2)+':'+substring(@date,11,2)+':'+substring(@date,13,2))
---------------------------------------------------------------------------------
/*
-------------------------
2012-08-27 19:22:22
*/
--SQL Server
DECLARE @i VARCHAR(30)
SET @i = '20120827192222'
SELECT CONVERT(VARCHAR(10), CONVERT(DATETIME, LEFT(@i, 8), 120), 120) + ' '
+ SUBSTRING(@i, 9, 2) + ':' + SUBSTRING(@i, 11, 2) + ':' + RIGHT(@i, 2)
--2012-08-27 19:22:22