当年第一个月 SQL> select to_char(sysdate,'yyyy')||'01' from dual;
TO_CHA ------ 201501
当前年,月 SQL> select to_char(sysdate,'yyyymm') from dual;
TO_CHA ------ 201503
2023-08-20 10:28:40
当年第一个月 SQL> select to_char(sysdate,'yyyy')||'01' from dual;
TO_CHA ------ 201501
当前年,月 SQL> select to_char(sysdate,'yyyymm') from dual;
TO_CHA ------ 201503