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
extract(month from sysdate) month,
extract(day from sysdate) day,
extract(hour from systimestamp) hour,
extract(minute from systimestamp) minute
from dual