[SQL] EXTRACT, TO_TO_CHAR : 날짜에서 특정 값 가지고 오기

EXTRACT 활용

SELECT 
    SYSDATE
    , EXTRACT(YEAR FROM SYSDATE)  AS year
    , EXTRACT(MONTH FROM SYSDATE) AS month
    , EXTRACT(DAY FROM SYSDATE)   AS day
    , EXTRACT(HOUR FROM CAST(SYSDATE AS TIMESTAMP))   AS hour
    , EXTRACT(MINUTE FROM CAST(SYSDATE AS TIMESTAMP)) AS minute
    , EXTRACT(SECOND FROM CAST(SYSDATE AS TIMESTAMP)) AS second
FROM dual

 

 

TO_CHAR 활용

SELECT 
    SYSDATE
    , TO_CHAR(SYSDATE, 'YYYY') AS year
    , TO_CHAR(SYSDATE, 'MM')   AS month
    , TO_CHAR(SYSDATE, 'DD')   AS day
    , TO_CHAR(SYSDATE, 'HH24') AS hour
    , TO_CHAR(SYSDATE, 'MI')   AS minute
    , TO_CHAR(SYSDATE, 'SS')   AS second
FROM dual