title: How to convert a string format yyyy-mm-dd to dd/mm/yyyy
body: <p>Ive currently got an issue with converting a string field in a ms sql table to my desired date format.</p>
  
  <p>previously i have always used </p>
  
  <pre><code>CONVERT(date,c.INP_DATE ,103)
  </code></pre>
  
  <p>but this gives me the error </p>
  
  <pre><code>[Err] 22007 - [SQL Server]Conversion failed when converting date and/or time from character string.
  </code></pre>
  
  <p>two sample records i have are 2013-09-18  and 2013-09-18 17:17:32.0000000  which i receive from an import via mysql.  I need these converted to dd/mm/yyyy with time where applicable.</p>
  
  <p>Any help from any gurus out there is appreciated :)</p>