code_junkie

Converting XML Datetime to SQL Datetime

Nov 11th, 2011
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. Declare @Xml Xml
  2. Set @Xml = '<Root><DateFrom>2008-10-31T00:00:00</DateFrom></Root>'
  3.  
  4. Declare @DateFrom DateTime
  5. Set @DateFrom = ?????
  6.  
  7. Declare @Xml Xml
  8. Set @Xml = '<Root><DateFrom>8/10/2008</DateFrom></Root>'
  9.  
  10. Declare @DateFrom DateTime
  11. Select @DateFrom= t.b.value('DateFrom[1]', 'datetime')
  12. from @xml.nodes('//Root') t(b)
Add Comment
Please, Sign In to add comment