[오라클] ORACLE 날짜 쿼리

SELECT TO_CHAR(SYSDATE, 'YYYY') AS SYS_YEAR4,

       TO_CHAR(SYSDATE, 'MM')   AS SYS_MONTH,

       TO_CHAR(SYSDATE, 'DD')   AS SYS_DATE,

       TO_CHAR(SYSDATE, 'HH24') AS SYS_HOUR24,

       TO_CHAR(SYSDATE, 'HH12') AS SYS_HOUR12,

       TO_CHAR(SYSDATE, 'MI')   AS SYS_MINUTE,

       SYSDATE - 1              AS MINUSE_DATE

FROM DUAL;