| Welcome to WebmasterWorld Guest from 188.8.131.52 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Grouping query by day using a timestamp|
Right now it groups it by second.
| 10:23 pm on May 26, 2007 (gmt 0)|
Hello, I'm trying to gather some information from my database but I need to group it by the day.
I have a timestamp in my database called "created" in the format of yyyy-mm-dd hh:mm:ss.
Right now if I group by created, its grouping my users all the way down to the second. Is it possible to make my grouping by day?
Also, how might I make sure that my user counts are sorted by the creation date, where the most recent day is listed first?
$query=mysql_query("SELECT COUNT(users) FROM database GROUP BY created");
| 11:19 am on May 27, 2007 (gmt 0)|
this may work for you:
|$query=mysql_query("SELECT COUNT(users), TO_DAYS(created) AS day FROM database GROUP BY day DESC"); |
| 7:07 pm on May 27, 2007 (gmt 0)|
Thank you for your help. It works perfectly and is a very useful tool I can add to my toolbox.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved