if both date is same then difference gives 1 day in sql query code example

Example: sql check if date is between 2 dates

SELECT startDate, endDate
FROM YourTable
WHERE '2012-10-25' between startDate and endDate