SELECT TRUNC(SYSDATE)+1-1/86400 FROM dual; —2018/8/3 23:59:59 SELECT TRUNC(SYSDATE)+1/ 86400 FROM DUAL;—2018/8/3 0:00:01