CODE EXAMPLE FOR SQL

oracle sql day of month from date

select extract(day from systimestamp) from dual;