title: How to convert datetimeoffset(7) to datetime in SQL Server.?
body: <p>I want to convert <code>datetimeoffset(7)</code> to <code>datetime</code> in SQL Server.</p>
  
  <p>For example: my <code>datetimeoffset(7)</code> is: <code>2014-11-07 00:00:00.0000000 +05:30</code></p>
  
  <p>I want convert to <code>Datetime</code> like this: <code>20141107</code> (Style 112) without using <code>varchar</code>.</p>