假设你的两个字段是 dateA dateB
传入的值是 testA testB那么,二者有交集的情况可以如下表示:where (testA between dateA and dateB) or (testB between dateA and dateB)你现在需要的是没有交集的,那就取反即可where not ((testA between dateA and dateB) or (testB between dateA and dateB))
传入的值是 testA testB那么,二者有交集的情况可以如下表示:where (testA between dateA and dateB) or (testB between dateA and dateB)你现在需要的是没有交集的,那就取反即可where not ((testA between dateA and dateB) or (testB between dateA and dateB))
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货