-- 单独的截取出年月日
--方法一: extract(year\month\day from sysdate)
Select Extract(YEAR from sysdate) from dual;
Select Extract(MONTH from sysdate) from dual;
Select Extract(DAY from sysdate) from dual;
--方法二:to_number(to_char(sysdate,'yyyy|MM|dd'))
Select to_number(to_char(sysdate,'yyyy')) from dual ;
Select to_number(to_char(sysdate,'mm')) from dual ;
Select to_number(to_char(sysdate,'dd')) from dual ;