Hi,
In your last comment you said that you're using
SQL Server 2005, not 2008. In SQL Server 2005 you could use built-in XQuery functions to do such conversion.
Example:
SELECT CAST('' AS XML).value('xs:dateTime("2013-10-10T00:00:00+05:30")', 'DATETIME');
xs:dateTime function converts time to local time (based on the time zone).