How to find a between dates using sql?
- by rajeeshmenoth
How to reject without saving dates in database?
Eg: the two columns in a database are from_date and to_date
From date : 25/08/2014
To date : 29/08/2014
Problem: the above dates are saved in a two fields like from_date and to_date (room reservation booking), the next reservation details I don't want the date between 25/08/2014 to 29/08/2014. The between dates are not saved in database. Only the from date and to date are saving into the database.
How to block between date using sql?