I have to columns in my table (check\_in and checkout). Both of them has this format `dd-mm-yyyy`. I want to check if there is any date available between my two paramaters(inputs). 

I tried like this:

```
select * from rezervare where date(check_out) > date('my_checkout_input') 

```

but this works only in a few cases. If i have a reservation between **12-03-2015 - 15-03-2015** and another reservation between **17-03-2015 and 20-03-2015**. It will not take the date between **16-03-2015** as a free date. Can you give me some ideas ?