title: SQL to display and order by converted date
body: <p>Is it possible to use SQL to display a date in a new format e.g. dd-mm-yyyy and then sort by converted the date?</p>
  
  <p>I tried something like:</p>
  
  <pre><code>SELECT CONVERT(varchar(10), [Date Depart], 105) AS [Date Depart]
  FROM FLIGHT
  ORDER BY CONVERT(varchar(10), [Date Depart], 105) DESC
  </code></pre>
  
  <p>It is not working on MS SQL Server. It it still sort by VARCHAR.</p>