title: Cast Datetime offset to Date
body: <p>I have the date column in datetimeoffset format.</p>
  
  <pre><code>2016-01-09 05:49:06.3744350 +00:00
  </code></pre>
  
  <p>I want to convert it to only date format, e.g. <code>2016-01-09</code>.
  I was able to convert datetimeoffset to datetime2 with this query.</p>
  
  <pre><code>convert(datetime2, sampleDate, 1)  as date
  </code></pre>
  
  <p>Would be much obliged if I could know how to convert this to the desired format in MS SQL.</p>