title: Convert varchar dd/mm/yyyy to dd/mm/yyyy datetime
body: <p>I'm trying to convert a date in a <code>varchar</code> column in the <code>dd/mm/yyyy</code> format into the datetime <code>dd/mm/yyyy</code> format, so then I can run date range queries on the data.</p>
  
  <p>So far I have the following which is not working</p>
  
  <pre><code>CONVERT(varchar, CAST(date_started AS datetime), 103)
  </code></pre>
  
  <p>I have also tried</p>
  
  <pre><code>convert(date_started as datetime, 103)
  </code></pre>
  
  <p>I need to make sure the output is as <code>dd/mm/yyyy</code> as we're in the UK and not the <code>mm/dd/yyyy</code> format</p>