Monkuar Posted February 1, 2012 Share Posted February 1, 2012 With unixtimestamps? I have let's say 20records, and like 5 of them are from January and 15 are in February, how would I go about showing all the records that were just in February (2012) or maybe 2013? (trick is using timestamps) Pretty much sort the records by each Monthy, by using unixtimestamp as the value in the db field, possible? Link to comment https://forums.phpfreaks.com/topic/256197-how-to-group-my-query-by-date/ Share on other sites More sharing options...
Pikachu2000 Posted February 1, 2012 Share Posted February 1, 2012 You can pull them into standard date/time format with MySQL's FROM_UNIXTIME() function. Link to comment https://forums.phpfreaks.com/topic/256197-how-to-group-my-query-by-date/#findComment-1313381 Share on other sites More sharing options...
Monkuar Posted February 1, 2012 Author Share Posted February 1, 2012 You can pull them into standard date/time format with MySQL's FROM_UNIXTIME() function. thanks bunch' topic resolved Link to comment https://forums.phpfreaks.com/topic/256197-how-to-group-my-query-by-date/#findComment-1313384 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.