title: Convert from varchar formatted as 'dd/mm/yyyy hh:mm:ss' to DateTime
body: <p>I'm stuck with the following. How do I convert strings that are formatted like the following into DateTime type?</p>
  
  <pre><code>SELECT CONVERT(DATETIME,LEFT('26/03/2012 00:00:00',10))
  </code></pre>
  
  <p>Error on the above is as follows:</p>
  
  <blockquote>
    <p>The conversion of a varchar data type to a datetime data type resulted
    in an out-of-range value.</p>
  </blockquote>