title: How to convert a "dd/mm/yyyy" string to datetime in SQL Server?
body: <p>I tried this</p>
  <pre><code>SELECT convert(datetime, '23/07/2009', 111)
  </code></pre>
  <p>but got this error</p>
  <blockquote>
  <p>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.</p>
  </blockquote>
  <p>However</p>
  <pre><code>SELECT convert(datetime, '07/23/2009', 111)
  </code></pre>
  <p>Is OK though</p>
  <p>How to fix the 1st one?</p>