Fábrica de Oracle

SELECT EXTRACT(DAY FROM SYSDATE) AS DIA       , EXTRACT(MONTH FROM SYSDATE) AS MES       , EXTRACT(YEAR FROM SYSDATE) AS ANO   FROM DUAL;