Extract Year from Date Oracle

Extract Year from Date Oracle

                             Extract function extracts date parts. such as year,month,day, hours,minutes,seconds,fractions and time zone.

Extracting/Getting Year from date/timestamp column

Extract Year for Sysdate

            SQL>select extract(year from sysdate)  from dual

 Extract year from orderdate column

           SQL>select extract(year from orderdate)  from orders

Extract year from string date 

           SQL>select extract(year from to_date('2020-12-12','yyyy-mm-dd'))  from dual 

Extract Year from current_timestamp

           SQL>select extract(year from current_timestamp) from dual;

Tags: using extract function, Extract function in oracle, get current year, get year from date column