SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I find the first day of the next month two years/one year from now?

2930134Aug 11 2015 — edited Aug 11 2015

Hello,

I need to find the first day of the next month two years ago based on the current day.

For example: If today's date is 2015/08/31 then I need to find the date range between 2015/08/31 and 2013/09/01. How do I write a SQL that can automate this calculate instead of hard-coding the values. Please do help me out with this so that I can build the SQL that can produce the desired output.

Thank you,

Dhilip

This post has been answered by Nick Strange on Aug 11 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2015

Added on Aug 11 2015

3 comments

1,385 views