I am trying to make an availability calender and need to know how can I compare date when fetching it.
My DB is
id start_date end_date status
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.