title: SQL Error : Conversion failed when converting date and/or time from character string
body: <p>I'm trying to convert a <code>varchar</code> column to <code>date</code> or <code>datetime</code> but I don't understand why it's not possible it should work and I don't see any kind of error.</p>
  <p>The column values is <code>31-07-2017</code> and the type is <code>Varchar(250)</code>. I tried <code>convert</code> and <code>cast</code> and I get the same error:</p>
  <blockquote>
  <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  <p>Does anyone have any idea on why it's like this?</p>