select to_char(sysdate,’YYYY/MM/DD’) FROM DUAL; — 2007/09/20 select to_char(sysdate,’YYYY’) FROM DUAL; — 2007 select to_char(sysdate,’YYY’) FROM DUAL; — 007 select to_char(sysdate,’YY’) FROM DUAL; … 更多