intersection between to date intervals code example
Example 1: how to check time overlap
public function check_time_overlap($start_time1, $end_time1, $start_time2, $end_time2) {
return (($start_time1) <= ($end_time2) && ($start_time2) < ($end_time1) ? true : false);
}
// true: overlap
// falseL not overlap
Example 2: check if two date ranges overlap sql server
(StartDate1 <= EndDate2) and (StartDate2 <= EndDate1)