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;

Advertisements

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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s