title: How can I express 24 hour time as 12 hour time when using timestamp without timezone in PostgreSQL 9.1?
body: <p>How can I express 24 hour time as 12 hour time when using timestamp without timezone in PostgreSQL 9.1? </p>
  
  <p>More specifically, I inserted order data into a database and I need to extract it back in its original state. </p>
  
  <p>Original data: <code>06/10/2013 12:43:30</code><br/>
  Data in DB: <code>2013-06-10 04:43:30+00</code></p>
  
  <p>If I query order data like:<br/><code>SELECT order_date AT TIME ZONE('EDT') ...</code> 
  I return <code>2013-06-10 00:43:30</code></p>
  
  <p>I need the <code>00</code> in the time to show as <code>12</code>. How can I do this? </p>