title: SQL time 24 hour to 12 hour format
body: <p>I have my table something like this:</p>
  
  <pre><code>+----------------+------------+
  |      Date      +    Time    |
  |-----------------------------|
  | 2015-09-23     | 17:20:25   |
  | 2015-09-23     | 17:25:27   |
  | 2015-09-24     | 06:29:27   |
  -------------------------------
  </code></pre>
  
  <p>I want only to get the time column and I want it to display in 12 hour format. Something like this:</p>
  
  <pre><code>5:20 P.M.
  5:25 P.M.
  6:29 A.M.
  </code></pre>
  
  <p>I used this query: <code>SELECT time FROM attendance WHERE 1</code> </p>