check date between two dates in sql 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: difference in dates sql

SELECT (END_DATE - START_DATE) Days-Total FROM MyTable
/*this works for oracle sql*/