年:
SQL> select to_char(sysdate,'yyyy') from dual;TO_CHAR(SYSDATE,'YYYY')
-----------------------
2004
月:SQL> select to_char(sysdate,'mm') from dual;TO_CHAR(SYSDATE,'MM')
---------------------
08
日:
SQL> select to_char(sysdate,'dd') from dual;TO_CHAR(SYSDATE,'DD')
---------------------
30年日:SQL> select to_char(sysdate,'yyyy-dd') from dual;TO_CHAR(SYSDATE,'YYYY-DD')
--------------------------
2004-30年月:
SQL> select to_char(sysdate,'yyyy-mm') from dual;TO_CHAR(SYSDATE,'YYYY-MM')
--------------------------
2004-08月日:
SQL> select to_char(sysdate,'mm-dd') from dual;TO_CHAR(SYSDATE,'MM-DD')
------------------------
08-30
SQL> select to_char(sysdate,'yyyy') from dual;TO_CHAR(SYSDATE,'YYYY')
-----------------------
2004
月:SQL> select to_char(sysdate,'mm') from dual;TO_CHAR(SYSDATE,'MM')
---------------------
08
日:
SQL> select to_char(sysdate,'dd') from dual;TO_CHAR(SYSDATE,'DD')
---------------------
30年日:SQL> select to_char(sysdate,'yyyy-dd') from dual;TO_CHAR(SYSDATE,'YYYY-DD')
--------------------------
2004-30年月:
SQL> select to_char(sysdate,'yyyy-mm') from dual;TO_CHAR(SYSDATE,'YYYY-MM')
--------------------------
2004-08月日:
SQL> select to_char(sysdate,'mm-dd') from dual;TO_CHAR(SYSDATE,'MM-DD')
------------------------
08-30
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货