isedeasy Posted December 6, 2010 Share Posted December 6, 2010 I want to do a query that finds out how many users joined over the past month grouped into days (for a chart). The problem is that I have the date registered as an integer 'time()'. How do I group by day? Quote Link to comment https://forums.phpfreaks.com/topic/220854-group-into-days/ Share on other sites More sharing options...
praveenhotha Posted December 6, 2010 Share Posted December 6, 2010 try using from_unixtime(date,'%Y %M %D) as tm group by tm Quote Link to comment https://forums.phpfreaks.com/topic/220854-group-into-days/#findComment-1143682 Share on other sites More sharing options...
isedeasy Posted December 6, 2010 Author Share Posted December 6, 2010 Thanks, that's exactly what I was looking for Quote Link to comment https://forums.phpfreaks.com/topic/220854-group-into-days/#findComment-1143689 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.