mysql query by month/unix timestamp

[freeups]

All my dates in my my sql database are in unix timstamps.
I am trying to create a sql query that will select records by selecting a month. So for example I have to create a query rhat will select all entries between 1st jun and 1st july (1117609200 and 1120201200) which should not be that hard.

My question is Is there a function that will generate what the timestamps should be automatically instead of me having to calculate them manually.

Thanks

[mrhappiness]

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html