How to get datewise results?

[Tapan]

Hello,

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 ?

Thanks.

[r937]

@Tapan

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

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

simple, innit

[Tapan]

@r937

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

simple, innit

Hi,

Thanks it was so easy.

Thanks again.