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
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
转载于:https://www.cnblogs.com/bsdbqling/p/9269119.html