gill__hong的博客

ORACLE时间相关的查询整理–指定日期的季度Select to_char(sysdate,‘Q’) from dual;–指定日期的月份Select to_char(sysdate,‘MM’) from dual;–当年第几周Select to_char(sysdate,‘WW’) from dual;–本月第几周Select to_char(sysdate,‘W’) from dual ;–当月第几天Select to_char(sysdate,‘DD’) from dual;–