title: Convert from varchar into date in SQL Server
body: <p>This looks easy solution but I can't seem to figure out as to why this is not working for me. I have a column that has data like this:</p>
  
  <pre><code>DateField
  ----------
  12/16/2016
  11/06/2016
  </code></pre>
  
  <p>All I want to do is to convert from <code>varchar</code> into a <code>date</code> column, but I am getting this error:</p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  
  <p>Here is my simple query:</p>
  
  <pre><code>select convert (date, DateField) as convertedField 
  from myTable
  </code></pre>