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;

One thought on “First Day and Last Day of Current Month Oracle

  1. 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;” >

Leave a Reply