title: Format timestamp from MYSQL query
body: <p>I have a mysql query that has a column CreationDate in the format of "timestamp".  Example:</p>
  
  <pre><code>2013-03-27 18:32:45
  </code></pre>
  
  <p>I would like for the sql query to format it in this fashion (12hr format with seconds):</p>
  
  <pre><code>Friday 3/28/2013 12:52:34 PM
  </code></pre>
  
  <p>I would like to handle this at the sql level rather than php or .js, etc.</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT a.ID, a.CreationDate, a.Content, a.Type, u.Nickname
  FROM Announcements a 
  INNER JOIN Accounts u ON a.FromAccountID = u.AccountID
  WHERE a.Status  = '1' AND u.Status = '1'
  ORDER BY a.ID DESC
  </code></pre>