title: How do I convert dd/mm/yy into date datatype
body: <p>I am able to convert the following to a <code>varchar</code> type</p>
  
  <pre><code>SELECT CONVERT(VARCHAR(11),'01/02/14',103)
  </code></pre>
  
  <p>I am getting an error while converting the above date to a <code>date</code> data type</p>
  
  <pre><code>SELECT Convert(date,'01/02/14',103)
  </code></pre>
  
  <p>I got the error saying </p>
  
  <pre><code>Msg 241, Level 16, State 1, Line 1
  Conversion failed when converting date and/or time from character string.
  </code></pre>
  
  <p>I also tried the following but didn't work.</p>
  
  <pre><code>SELECT Convert(date,CONVERT(VARCHAR(11),'01/02/14',103),103)
  </code></pre>
  
  <p>How can I convert to a <code>date</code> type?</p>