日起函数取年月日

select extract(YEAR from sysdate) year,
               extract(month from sysdate) month,
               extract(day from sysdate) day,
               extract(hour from systimestamp) hour,
               extract(minute from systimestamp) minute
          from dual