SELECT * FROM screen AS n
WHERE DATE_FORMAT(n.trans_time, '%H:%i:%S') >= '20:00:00'
AND DATE_FORMAT(n.trans_time, '%H:%i:%S') <= '24:00:00'
SELECT * FROM screen AS n
WHERE DATE_FORMAT(n.trans_time, '%H:%i:%S') >= '20:00:00'
AND DATE_FORMAT(n.trans_time, '%H:%i:%S') <= '24:00:00'