How to Compare and fetch date in Cakephp ?

I am trying to make an availability calender and need to know how can I compare date when fetching it.

My DB is


Now suppose I want to fetch booking in next month, i.e. from 2010-03-01 to 2010-04-01. How should I fetch this data ? I did try comparing directly using an and condition but it didnt help.

The format in DB is yyyy-mm-dd and I used the same to compare. But direct comparison does not work.