HOW TO GET MONTH AND YEAR IN ORACLE FROM DATE OLUMN code example Example: oracle sql day of month from date select extract(day from systimestamp) from dual;