extract 从日期中截取部分日期

SQL> select extract (year from sysdate) year, extract (month from sysdate) month, extract (day from sysdate) day from dual;

YEAR MONTH DAY
---------- ---------- ----------
  2018           5            4