title: TIME_FORMAT(HOUR(`dPostTime`), '%l %p') Returning Same Values
body: <p>The following is my query:</p>
  
  <pre><code>SELECT COUNT(*), TIME_FORMAT(HOUR(`dPostTime`), '%l %p') AS `hr`, HOUR(`dPostTime`) AS 'hour' FROM `tblQA` WHERE dPostDateTime &gt;= '$_POST[startDate]' AND dPostDateTime &lt;= '$_POST[endDate]' AND dPostTime &lt;&gt; '0000-00-00 00:00:00' GROUP BY `hour`"
  </code></pre>
  
  <p>I have the data posting to a table through a php while loop. It's returning all 12 AM, instead of 1 AM, 2AM, 3AM, etc...</p>
  
  <p>If I use just HOUR('dPostTime') it displays properly, BUT i'm looking to format the date instead of just returning a value.</p>
  
  <p>Thanks!</p>