mybatis-查询两个时间段有交集的记录

 SELECT COUNT(*) FROM (
        SELECT *
        FROM MS_YLJG_KS_ZJ_PB
        WHERE RQ = '2020-02-28' AND ZJID ='d706663c-36a2-11ea-ad8f-286ed48a3336' ) 
  A				
WHERE	  (
		 	TIME_FORMAT(A.KSSJ, '%H%:%i') >= '16:00' AND TIME_FORMAT(A.KSSJ, '%H%:%i') <= '18:00'
	      )
 	 OR   (
		    TIME_FORMAT(A.KSSJ, '%H%:%i') <= '16:00' AND TIME_FORMAT(A.JSSJ, '%H%:%i') >= '16:00'
		   )
	 OR   (
			   TIME_FORMAT(A.JSSJ, '%H%:%i') >= '16:00' AND TIME_FORMAT(A.JSSJ, '%H%:%i') <= '18:00'
		   )

我想格式mysql格式化“08:54”，使用date_format("08:45",'%H:%i') ,但是返回null。

解决办法：

关于时分秒要使用time_format("08:45",'%H:%i') 。

数据库字段：
res_begin_time ：开始时间
res_end_time：结束时间

传入的参数：
resBeginTime：开始时间
resEndTime：结束时间

SELECT
*
FROM
	table_name
WHERE
	(
		res_begin_time >= #{resBeginTime} AND res_begin_time <= #{resEndTime}
	)
	OR (
		res_begin_time <= #{resBeginTime} AND res_end_time >= #{resEndTime}
	)
	OR (
		res_end_time >= #{resBeginTime} AND res_end_time <= #{resEndTime}
	)