title: SQL Server : varchar to Date Conversion/Casting Error
body: <p>If I use this</p>
  
  <pre><code>SELECT CONVERT(DATE, '26/03/2014', 101)
  </code></pre>
  
  <p>I get an error:</p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  
  <p>But if I use this</p>
  
  <pre><code>SELECT CONVERT(DATE, '26/03/2014', 103)
  </code></pre>
  
  <p>There's no error and this is the result returned:</p>
  
  <pre><code>2014-03-26
  </code></pre>
  
  <p>I don't understand why the first code is not working, as far as I searched and understand is that <code>101</code> is for US date and <code>103</code> is for UK/French Date.</p>