how to check if the given date is between two date in sql code example
Example: sql check if date is between 2 dates
SELECT startDate, endDate
FROM YourTable
WHERE '2012-10-25' between startDate and endDate
SELECT startDate, endDate
FROM YourTable
WHERE '2012-10-25' between startDate and endDate