Query to get the Time in YYYY format

SELECT TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') FROM DUAL
-->To get the time in 24hr 

SELECT TO_CHAR(SYSDATE,'YYYY/MM/DD HH12:MI:SS') FROM DUAL
--> To get the time in 12hr