title: Convert DDMMYYYY to YYYYMMDD date format in sql server?
body: <p>I have a date in table as <code>"26052016"</code> in format <code>DDMMYYYY</code> 
  I want to convert this date to <code>"YYYYMMDD"</code> format.</p>
  
  <p>Any idea<br>
  I have tried this method</p>
  
  <pre><code>select CONVERT(varchar(8),[doc-date],112) FROM C034_PDK_ParallelBillingSourceExtract
  </code></pre>
  
  <p>But this is gives me the same date as a result.</p>
  
  <p>Please help me  </p>