two date range overlap identify sql server 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: javascript check if two date ranges overlap
if((StartDate1 <= EndDate2) && (StartDate2 <= EndDate1)) {
//overlapping dates
}