sql query where time ให้แสดงข้อมูล time between 19.45:01 and 7:00:00 ข้อมูลไม่เสดง

SELECT *
FROM your_table
WHERE (time BETWEEN '19:45:01' AND '23:59:59')
   OR (time BETWEEN '00:00:00' AND '07:00:00');

SELECT *
FROM your_table
WHERE (CONCAT(date, ' ', time) BETWEEN '2024-11-12 19:45:01' AND '2024-11-12 23:59:59')
   OR (CONCAT(date, ' ', time) BETWEEN '2024-11-13 00:00:00' AND '2024-11-13 07:00:00');