Extract Day from Date Oracle

Extract Day   from Date Oracle

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

Extracting/Getting Day   from date/timestamp column

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

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

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

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

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