--获取年
select extract(year from date'2011-05-17') year from dual;
--获取月
select extract(month from date'2011-05-17') month from dual;
--获取日
select extract(day from date'2011-05-17') day from dual;
--获取年
select extract(year from date'2011-05-17') year from dual;
--获取月
select extract(month from date'2011-05-17') month from dual;
--获取日
select extract(day from date'2011-05-17') day from dual;
转载于:https://www.cnblogs.com/jwdd/p/10046274.html