Atom RSS date,ISO8601 to SQL date conversion using SQL Server

In my earlier post I had listed the C# code to convert the ISO8601 date to SQL date.Here's the same in SQL Server.

select convert(datetime, '2008-10-23T18:52:47.513Z', 127)