数据库表，列1名：aTime 列2名：bTime
aTime是字符串类型，bTime是datetime类型
aTime中的字符串格式是：20141215022118 请教，Select convert怎么样转换成日期类型，和bTime做日期加减，或其他计算呢？
------解决思路----------------------
WITH table1(atime,btime) AS (
SELECT '20141215022118', GetDate()
)
SELECT Convert(datetime,
LEFT(atime,4)+'-'+SUBSTRING(atime,5,2)+'-'+SUBSTRING(atime,7,2)+' '+
SUBSTRING(atime,9,2)+':'+SUBSTRING(atime,11,2)+':'+SUBSTRING(atime,13,2),
120) atime,
btime
FROM table1
atime btime
----------------------- -----------------------
2014-12-15 02:21:18.000 2015-01-13 15:15:34.950
------解决思路----------------------
declare @i varchar(50)
set @i=20141215022118
print cast(left(@i,4)+'-'+substring(@i,5,2)+'-'+substring(@i,7,2)+' '
+substring(@i,9,2)+':'+substring(@i,11,2)+':'+substring(@i,13,2) as datetime)