silvercover Posted October 19, 2011 Share Posted October 19, 2011 I have a table like this: and date field format is in epoch. I have to group every row that belongs to same day and show them in a separate group. How can I do that in MySQL? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/249408-epoch-time-and-mysql-query/ Share on other sites More sharing options...
fenway Posted October 19, 2011 Share Posted October 19, 2011 Same day, or same date? Quote Link to comment https://forums.phpfreaks.com/topic/249408-epoch-time-and-mysql-query/#findComment-1280607 Share on other sites More sharing options...
silvercover Posted October 19, 2011 Author Share Posted October 19, 2011 Same day. Quote Link to comment https://forums.phpfreaks.com/topic/249408-epoch-time-and-mysql-query/#findComment-1280614 Share on other sites More sharing options...
fenway Posted October 19, 2011 Share Posted October 19, 2011 So you want to group all the Mondays together? Quote Link to comment https://forums.phpfreaks.com/topic/249408-epoch-time-and-mysql-query/#findComment-1280635 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.