I have tried to convert XML datetime value to SQL datetime by executing the below statement, though I feel there might be some other way of converting the value in SQL server 2000.
declare @TestXMLTime as varchar(50)
set @TestXMLTime ='2010-01-01T00:00:07+05:30'
select cast(left(@TestXMLTime,10)+' '+right(left(@TestXMLTime,19),8) as datetime)
View Complete Post