将字段内的年月日截取出来

 select extract (year from sysdate) year, extract (month from sysdate) month, extract (day from sysdate) day from dual; --注意：只能从一个data类型中截取年月日