title: How to change the date format in sql queries
body: <p>I have date and time format as </p>
  
  <pre><code>2011-12-31 05:12:23
  </code></pre>
  
  <p>And i need to change it as follows: </p>
  
  <pre><code>Monday @ 2:23AM 21/11/2011
  </code></pre>
  
  <p>I am using this sql query:</p>
  
  <pre><code>SELECT * FROM cms_content order by ID DESC;
  </code></pre>
  
  <p>where i have the fields as follows in my table named cms_content:</p>
  
  <pre><code>id, idname, author, date, title, body
  </code></pre>
  
  <p>So how to do this so that i can get the desired result? </p>