read nodes from xml existing ina table

[EDN Admin]

Hi All,<br/>
<br/>
Iam having a table with one column as primaryID and the other columen consists of xml as shown below :<br/>
<br/>
ID ReturnMessage<br/>
<br/>
1 <ReturnMessage id="3670704774 <MessageStatus code="211" time="2011-12-19 17:56:49 unable to resolve message identity</MessageStatus></ReturnMessage><br/>
<br/>
I want a sql query to show the output as follows reading the time node from the xml in above column:<br/>
<br/>
<br/>
ID Time <br/>
1 2011-12-19 17:56:49<br/>
<br/>
Iam a newbie to this field, Kindly help me on the same<br/><hr class="sig ram

View the full article