webbwarsaw
New Member
I have an \[code\]xml\[/code\] data column without a schema in a table.It contains date elements which erroneusly have a time zone specification. For example:\[code\]<SomeRootElement> <AnotherElement> <ThisIsADate>2012-09-17T21:15:00-03:00</ThisIsADate> </AnotherElement></SomeRootElement>\[/code\]I'd like to create a T-SQL query (which might contain XQuery) to remove the time zone from all the elements that contain one, so the one above, for example, would be \[code\]2012-09-17T21:15:00\[/code\].It should update all the date elements in the document, regardless of the name.Is this possible?