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;

 

Category: SQLUncategorized

Tags:

One comment

  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

Article by: Shadab Mohammad