title: SQL Server - How to convert varchar to date
body: <p>I have a table containing StartDate in the format dd/mm/yyyy and yyyy-mm-dd.
  I want to convert this varchar column to DATE type in the format DD/MM/YYYY.</p>
  
  <p>I have tried the below.</p>
  
  <pre><code>select CONVERT(varchar(20),StartDate,103) AS [FormattedDate]
  </code></pre>
  
  <p>and</p>
  
  <pre><code>CONVERT(VARCHAR(20),(CAST([StartDate] AS DATE)),103)
  </code></pre>
  
  <p>I get the error -Conversion failed when converting date and/or time from character string.</p>
  
  <p>Pls suggest.</p>