Query to Select the First Day and Last Day of the Current Month
select trim(to_date(last_day(sysdate),'DD/MM/YYYY')) as lastday from dual; select trunc((sysdate),'month') as FirstDay from dual;
Query to Select the First Day and Last Day of the Current Month
select trim(to_date(last_day(sysdate),'DD/MM/YYYY')) as lastday from dual; select trunc((sysdate),'month') as FirstDay from dual;