select to_char(sysdate,'yyyy-mm-dd,hh24:mi:ss') from dual ;select to_char(sysdate,'mm') from dual ;
select to_char(sysdate,'yyyy') from dual ;
select to_char(sysdate,'dd') from dual ;
select to_char(sysdate,'yyyy') from dual ;
select to_char(sysdate,'dd') from dual ;
select to_char(sysdate,'yyyy') from dual
select to_char(sysdate,'dd') from dua