title: How to convert mysql time
body: <p>My time in mysql is in the form hh:mm:ss
  How can I convert that to 12 hour time and also remove the seconds, because they are all 00.</p>
  
  <p>ex:</p>
  
  <pre><code>14:30:00
  </code></pre>
  
  <p>mysql</p>
  
  <pre><code>$finalresult = mysql_query("SELECT * FROM events WHERE clubID IN (" . implode(',', $clubIDs) . ") ORDER BY date ASC, TIME(startTime) ASC");
  
  while($finalrow = mysql_fetch_assoc($finalresult)) {
  
  $originaltime = $finalrow['startTime'];
  $newtime = TIME_FORMAT($originaltime, '%h:%i %p');
  
  }
  </code></pre>