javascript-php how to put timestamps according to 24 hours one hours a day, one hours of display

We already have the data, but how do we show the data in 24-hour, one-hour format every one hours?
For example, 0 points-1 points: 5

   1点-2点：0   2点=3点：6   这个样子去展示。。。   

Reply content:

We already have the data, but how do we show the data in 24-hour, one-hour format every one hours?
For example, 0 points-1 points: 5

   1点-2点：0   2点=3点：6   这个样子去展示。。。   

Pro, you read it yourself, you think others can read it.
Check the MySQL manual, as long as the use of time format function on the line, I am too lazy to find.
Play for example Formattime (' y-m-d h ', ' 2006-11-23 18:00:05 ') can get results 2006-11-23 18 words
SELECT *, Formattime (' H ', time ) as from h yourtable where Formattime (' y-m-d ', time ) = ' 2016-02-30 ' ORDER byh

