Site icon EasyOraDBA

First Day and Last Day of Current Month Oracle

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;

 

Exit mobile version