T-SQL如何將YYYYMMDDHHmmssnnn轉換為datetime

DECLARE @tdatetime datetime;
DECLARE @ttimestamp varchar(20);
SET @ttimestamp = '20130829020000103';
SET @tdatetime = CONVERT(datetime,stuff(stuff(stuff(stuff(@ttimestamp, 9, 0, ' '), 12, 0, ':'), 15, 0, ':'),18,0,'.'));
select @tdatetime;DECLARE @tdatetime datetime;
DECLARE @ttimestam