oracle date change

select to_char(sysdate,'yyyy') from dual;-----2016
select to_number(to_char(sysdate,'MM'))||'月' from dual;----7月

SELECT 'V'||(to_char(SYSDATE,'iw') -to_char(last_day(add_months( SYSDATE,-1))+1,'iw')+1) FROM DUAL;---V1(取今天为本月第几周)

原文地址:https://www.cnblogs.com/flyrain/p/oracle_date.html