MySql sql语句处理两个时间段的重叠交集问题
SELECT
COUNT(*)
FROM
fp_configuration
WHERE
( '2019-10-20'<= effective_date AND '2019-10-24' >= effective_date )
OR ( '2019-10-20' <= expiration_date AND '2019-10-24' >= effective_date )
MySql sql语句处理两个时间段的重叠交集问题
SELECT
COUNT(*)
FROM
fp_configuration
WHERE
( '2019-10-20'<= effective_date AND '2019-10-24' >= effective_date )
OR ( '2019-10-20' <= expiration_date AND '2019-10-24' >= effective_date )