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? 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 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 Link to comment https://forums.phpfreaks.com/topic/220854-group-into-days/#findComment-1143689 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.