check if date range overlap sql 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)