Results 1 to 8 of 8
Oct 27, 2009, 12:57 #1
- Join Date
- Sep 2004
- 0 Post(s)
- 0 Thread(s)
Select and group based upon timestamp
I have a table containing view/click records. The time is stored in a unix timestamp and I need to be able to pull out all of them within the specific month/day (based off of timestamps), but more importantly and the part I don't know how to do is group them by hour. I need to be able to do this in a single query rather than looping through each hour.
Database is MySQL, language is PHP.