title: SQL Server 2012 convert datetime data from varchar to Date portion
body: <p>Have researched a lot, both on this site, and others, but still don't have a valid solution. I have a column of <code>varchar</code> datatype, it contains <code>DateTime</code> data. I need to store only the <code>Date</code> portion in a <code>Date</code> type column. Tried different ways of Cast, Convert, and other functions, but still haven't been able to make it work.</p>
  
  <p>Basically I want to convert this </p>
  
  <pre><code>Tue Apr 26 2016 13:54:53 GMT+0200 (CEST)
  </code></pre>
  
  <p>to </p>
  
  <pre><code>04/26/2016
  </code></pre>