Extract Month from Date Oracle

Extract Month  from Date Oracle

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

Extracting/Getting Month  from date/timestamp column

Extract Month  for Sysdate
            SQL>select extract(Month  from sysdate)  from dual;

 Extract Month  from orderdate column
           SQL>select extract(Month  from orderdate)  from orders;

Extract Month  from string date
           SQL>select extract(Month  from to_date('2020-12-12','yyyy-mm-dd'))  from dual ;

Extract Month  from current_timestamp
           SQL>select extract(Month  from current_timestamp) from dual;

Tags: using extract function, Extract function in oracle, get current Month , get Month  from date column,oracle 11g