Forum Moderators: open

Message Too Old, No Replies

group by financial months in mysql

         

xuletz

8:17 pm on Jun 20, 2011 (gmt 0)

10+ Year Member



hello,
I need to query a table and group results by financial months. this means that for example financial January dates from 1st of Jan to 4th of February.
I'd like to group in the query and not select by dates and group with php because this is costly time-wise. so any ideas?

xuletz

2:48 pm on Jun 27, 2011 (gmt 0)

10+ Year Member



nevermind. this had such a simple solution I can`t believe I didn`t think of it.