To get the year for current date

select extract(year from sysdate) from dual;

To get the year for current date:  will return 2016 for example for date 03-Jan-2016

Comments

Post a Comment