-- and to_char(o.d_cjrq, 'yyyy-mm-dd HH24:MI:SS') <= to_char(trunc(sysdate) +17/24 + 30/(24*60),'yyyy-mm-dd HH24:MI:SS')
SELECT to_char(trunc(sysdate) +17/24 + 30/(24*60),'yyyy-mm-dd HH24:MI:SS') FROM dual
SELECT to_char(trunc(sysdate) +17/24 + 00/(24*60),'yyyy-mm-dd HH24:MI:SS') FROM dual
SELECT to_char((trunc(sysdate,'d')+5) +17/24 + 30/(24*60),'yyyy-mm-dd HH24:MI:SS') FROM dual
SELECT to_char((trunc(sysdate,'d')+5) +17/24 + 00/(24*60),'yyyy-mm-dd HH24:MI:SS') FROM dual
04-09
1375
03-17
136