question

swathiaredath avatar image
swathiaredath asked

how can i cast a value in an xmlstring format to datetime that should be done within a forxml clause

Hi , i want to convert a value in xmlstring to datetime.xmlstring contain many columns ,installeddate is one of them.i want get its value as datetime.i used forxml clause to get the value so the casting also should be done within this forxml.how can i do this.help me plz..
sql-server-2008
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
can you share your query with some sample data? it seems a little vague. It may be as simple as wrapping the column with convert()
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.