title: Turning TIMESTAMP SQL into 12 hour time
body: <p>I am writing an app that allows people to schedule things for certain times and then displays them.  The time of the event is stored in the database as an SQL TIME, because there are things I'm doing in the DB that need this structure.</p>
  
  <p>However, on the output page I want the time to be in 12:00 am/pm format, but I don't want to run a conversion script every time I step through the database output loop.
  I don't want this:</p>
  
  <pre><code>while (database loop){
  convert to clean time
  output event info, with clean time
  }
  </code></pre>
  
  <p>because I think it is too much strain and unneccesary. Is there a way to do this better short of storing the time in the db twice (once in 24 hour and once in 12)?</p>