First Day and Last Day of Current Month Oracle

By Shadab Mohammad • Jan 18, 2017 • 1 comment

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;

Shariq Islam says:

January 18, 2017 at 5:49 pm

Hi

Please give me the suggestion of Row cache lock and how to prevent now

Shariq islam 9769046399 On 18 Jan 2017 18:16, “..:::: EasyOraDBA | Shadab Mohammad ::::..” wrote:

> easyoradba posted: “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;” >

Reply