SQL 判斷兩個時間段有重疊
兩個時間段:
a_start,a_end
b_start,b_end
公式:a_start <= b_end and a_end >= b_start
轉(zhuǎn)自:https://blog.csdn.net/hjg1224/article/details/90731761
兩個時間段:
a_start,a_end
b_start,b_end
公式:a_start <= b_end and a_end >= b_start
轉(zhuǎn)自:https://blog.csdn.net/hjg1224/article/details/90731761