I don't really understand what you are asking. If your table has a date column that has values are from the first of the month to the last of the month, then you can select BETWEEN 2 dates values, so
SELECT * FROM TABLE.NAME WHERE DATE_COLUMN BETWEEN '01.10.2009' AND '31.10.2009'
or you can select between any 2 dates you want to. I'm not sure if this is what you mean, so please can you clarify.