-- 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
03-17
134
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)