select * from test
where XR between sysdate+numtodsinterval(-24,'hour') and sysdate
SELECT * FROM 表名 where TIMESTAMPDIFF(hour,日期字段,sysdate()) <= 24
WHERE PREOPENDTIME>='${DATEDELTA(NOW(),-1)}'
WHERE PREOPENDTIME>= CURRENT_DATE-1DAYS