title: How to Convert Datetime to Date in dd/MM/yyyy format
body: <p>I want to write a query to get Date in dd/MM/yyyy format. (I do not want time).</p>
  
  <p>So i wrote query like </p>
  
  <pre><code>SELECT  Convert(varchar,A.InsertDate,103) as Tran_Date
  </code></pre>
  
  <p>But when i write order by Tran_Date, it is giving me the result in wrong order.</p>
  
  <p>Can some body please suggest what should i do.</p>
  
  <p>Thanks</p>