1 2 3 4 5 6 7 8 | -- 추가할것 있으면 댓글로 SELECT TO_CHAR(TRUNC(SYSDATE, 'YY' ), 'YYYY-MM-DD HH24:MI:SS' ) YYYY , TO_CHAR(TRUNC(SYSDATE, 'MM' ), 'YYYY-MM-DD HH24:MI:SS' ) MM , TO_CHAR(TRUNC(SYSDATE, 'DD' ), 'YYYY-MM-DD HH24:MI:SS' ) DD , TO_CHAR(TRUNC(SYSDATE, 'HH' ), 'YYYY-MM-DD HH:MI:SS' ) HH , TO_CHAR(TRUNC(SYSDATE, 'HH24' ), 'YYYY-MM-DD HH24:MI:SS' ) HH24 , TO_CHAR(TRUNC(SYSDATE, 'MI' ), 'YYYY-MM-DD HH24:MI:SS' ) MI FROM DUAL |