sql check if date is 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: mysql date between two dates

ex1:
SELECT * FROM `objects` 
WHERE  (date_field BETWEEN '2010-01-30 14:15:55' AND '2010-09-29 10:15:55')

ex2:
WHERE 
   requireddate BETWEEN 
     CAST('2003-01-01' AS DATE) AND 
     CAST('2003-01-31' AS DATE);

Example 3: sql get number of days between two dates

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

Tags:

Sql Example

Related