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? Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.