title: Converting XML Datetime to SQL Datetime
body: <p>I have an XML datatype and want to convert an element into a sql DateTime variable. How?</p>
  
  <p>e.g.</p>
  
  <pre><code>Declare @Xml Xml
  Set @Xml = '&lt;Root&gt;&lt;DateFrom&gt;2008-10-31T00:00:00&lt;/DateFrom&gt;&lt;/Root&gt;'
  
  Declare @DateFrom DateTime
  Set @DateFrom = ?????
  </code></pre>
  
  <p>How can I set @DateFrom with the date from the xml above?</p>