select to_char(sysdate,'d') from dual;--本周第几天 select to_char(sysdate,'dd') from dual;--本月第几天 select to_char(sysdate, 'w') from dual;--本月第几周 select to_char(sysdate+1, 'iw') from dual;--按星期一开始为一周
select to_char(sysdate,'d') from dual;--本周第几天 select to_char(sysdate,'dd') from dual;--本月第几天 select to_char(sysdate, 'w') from dual;--本月第几周 select to_char(sysdate+1, 'iw') from dual;--按星期一开始为一周
转载于:https://www.cnblogs.com/wolil/p/5646352.html