EXTRACT(DATE FROM code example

Example: oracle sql day of month from date

select extract(day from systimestamp) from dual;