Answers for "check if two dates are between two dates"

sql check if date is between 2 dates

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

How to calculate the difference between two dates

$datetime1 	= new DateTime('2020-10-11 16:52:52');
$datetime2 	= new DateTime('2020-10-13 16:52:52');
$interval 	= $datetime1->diff($datetime2);

echo $interval->format('%a days');