SELECT
CONVERT (
datetime,
SUBSTRING (intotime, 1, 8) + ' ' + SUBSTRING (intotime, 9, 2) + ':' + SUBSTRING (intotime, 11, 2)
)
FROM
table
SELECT
CONVERT (
datetime,
SUBSTRING (intotime, 1, 8) + ' ' + SUBSTRING (intotime, 9, 2) + ':' + SUBSTRING (intotime, 11, 2)
)
FROM
table