SELECT ID, (SELECT [akc194]+' '+[zke239]+',' FROM #tab WHERE ID=A.ID FOR XML PATH('')) AS '经办时间' FROM #tab A GROUP BY ID
select dateadd(ss,cast(SUBSTRING([zke239],1,LEN([zke239])-4) as int)*3600+cast(right(SUBSTRING([zke239],1,LEN([zke239])-2),2) as int)*60+cast(right([zke239],2) as int),cast([akc194]as datetime)) as '经办时间' from #tab
DECLARE @T TABLE(AKC194 VARCHAR(8),ZKE239 int); INSERT INTO @T ( AKC194, ZKE239 ) VALUES ( '20151208' -- AKC194 - varchar(8) , 85032 -- ZKE239 - int ),(20151202,223554)SELECT AKC194+STUFF(STUFF(ZKE239,3,0,':'),6,0,':') AS 日期格式 FROM (SELECT CAST(AKC194 AS DATETIME) AS AKC194,RIGHT(1000000+ZKE239,6) AS ZKE239 FROM @T) AS T/* 日期格式 2015-12-08 08:50:32.000 2015-12-02 22:35:54.000 */
SELECT ID,
(SELECT [akc194]+' '+[zke239]+',' FROM #tab
WHERE ID=A.ID
FOR XML PATH('')) AS '经办时间'
FROM #tab A
GROUP BY ID
select dateadd(ss,cast(SUBSTRING([zke239],1,LEN([zke239])-4) as int)*3600+cast(right(SUBSTRING([zke239],1,LEN([zke239])-2),2) as int)*60+cast(right([zke239],2) as int),cast([akc194]as datetime)) as '经办时间' from #tab
INSERT INTO @T
( AKC194, ZKE239 )
VALUES ( '20151208' -- AKC194 - varchar(8)
, 85032 -- ZKE239 - int
),(20151202,223554)SELECT
AKC194+STUFF(STUFF(ZKE239,3,0,':'),6,0,':') AS 日期格式
FROM (SELECT CAST(AKC194 AS DATETIME) AS AKC194,RIGHT(1000000+ZKE239,6) AS ZKE239 FROM @T) AS T/*
日期格式
2015-12-08 08:50:32.000
2015-12-02 22:35:54.000
*/