SQL> SELECT next_day(sysdate,'星期五')
  2    FROM DUAL
  3  ;


NEXT_DAY(SYSDATE,'星期五')
--------------------------
2018/3/9 10:55:59


SQL> SELECT  TO_DATE('01-1月-2007') FROM DUAL;


TO_DATE('01-1月-2007')
----------------------
2007/1/1