title: How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
body: <p>I'm hoping to convert a table which has a <code>DATETIMEOFFSET</code> field, down to a <code>DATETIME</code> field BUT recalculates the time by taking notice of the offset. This, in effect, converts the value to <code>UTC</code>.</p>
  
  <p>eg.</p>
  
  <pre><code>CreatedOn: 2008-12-19 17:30:09.0000000 +11:00
  </code></pre>
  
  <p>that will get converted to </p>
  
  <pre><code>CreatedOn: 2008-12-19 06:30:09.0000000
  </code></pre>
  
  <p>or </p>
  
  <pre><code>CreatedOn: 2008-12-19 06:30:09.0000000 + 00:00 -- that's a `DATETIMEOFFSET`, but `UTC`.
  </code></pre>
  
  <p>Cheers :)</p>