sql where date between two dates code example

Example 1: sql check if date is between 2 dates

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

Example 2: sql get number of days between two dates

DATEDIFF(DAY, '1/1/2011', '3/1/2011')