How to get datewise results?


I have a database table in which I am storing records with unix timestamp.

I now need to get records month wise and date wise. How do I do that ?

In month wise I should get say all records that are of month June then it should so all the records of June, 2011.

And when date wise it should then show all of the specific date.

How to achieve ?


SELECT stuff
  FROM daTable
 WHERE yourcolumn >= UNIX_TIMESTAMP('2011-06-01')
   AND yourcolumn  < UNIX_TIMESTAMP('2011-07-01')

simple, innit :cool:


Thanks it was so easy. :slight_smile:

Thanks again.