select to_char(to_date('2003-8-29','yyyy/mm/dd'),'yyyy') yyyy, to_char(to_date('2003-8-29','yyyy/mm/dd'),'mm') mm, to_char(to_date('2003-8-29','yyyy/mm/dd'),'dd') dd from dual;
SQL> select to_char(sysdate,'hh24') from dual;TO_CHAR(SYSDATE,'HH24') ----------------------- 09SQL> select to_char(sysdate,'ss') from dual;TO_CHAR(SYSDATE,'SS') --------------------- 10SQL> select to_char(sysdate,'mi') from dual;TO_CHAR(SYSDATE,'MI') --------------------- 09
SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;TO_CHAR(SYSDATE,'YY ------------------- 2003-08-29 12:30:43SQL>
to_char(to_date('2003-8-29','yyyy/mm/dd'),'mm') mm,
to_char(to_date('2003-8-29','yyyy/mm/dd'),'dd') dd from dual;
-----------------------
09SQL> select to_char(sysdate,'ss') from dual;TO_CHAR(SYSDATE,'SS')
---------------------
10SQL> select to_char(sysdate,'mi') from dual;TO_CHAR(SYSDATE,'MI')
---------------------
09
-------------------
2003-08-29 12:30:43SQL>