snippetsmania.com
Post and share your code snippets

declare @stringDate varchar(30);
declare @myXmlDate xml
declare @serializedDate datetime
declare @xQuery varchar(100)
set @stringDate = '2007-10-03T11:24:07.003+12:00'
set @myXmlDate = cast('' as xml) --Gets an empty Xml datatype
set @serializedDate = @myXmlDate.value('xs:dateTime(sql:variable("@stringDate"))', 'datetime')
select @serializedDate

source