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(取今天为本月第几周)
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(取今天为本月第几周)