You should use XQuery as follows:
SELECT ID, ReturnMessage.VALUE('(/ReturnMessage/MessageStatus/@time)', 'date')
This works only if the ReturnMessage's type is XML.
You can find more details on value() function
Whether you’re a construction worker, a forum moderator, or just someone that likes helping people. I think these
guidelines can be helpful in keeping you helpful when being helpful.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?