11. DATE Functions

Gives date

select trunc(sysdate,'MM') from dual;

select last_day(trunc(sysdate)) from dual

Gives day

select to_char(trunc(sysdate,'MM'),'DAY') from dual;

select to_char(last_day(trunc(sysdate)),'DAY') from dual;