Skip to Main Content
Forums

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!

First Day of Previous Quarter and Last Day of Previous Quarter

Sandy4312Apr 5 2018 — edited Apr 5 2018

  SELECT ADD_MONTHS(TRUNC(SYSDATE , 'Q'),-3) " First Day of Previous Quarter"   -- CONSTANT : 01-OCT-Previous Year(YYYY)

  FROM DUAL  -- First Day of Previous Quarter

  /

   SELECT (TRUNC(SYSDATE , 'Q') -1) "Last Day of Previous Quarter"   -- CONSTANT : 31-DEC-Previous Year(YYYY)

   FROM DUAL  -- Last Day of Previous Quarter

First Day of Previous Quarter

------------------------------

01-JAN-18                    

1 row selected.

Last Day of Previous Quarter

----------------------------

31-MAR-18                  

1 row selected.

At any point of time when I run my  program now and future , it should give 01-OCT-Previous Year(YYYY) and 31-DEC-Previous Year(YYYY) , Not sure what is wrong in my SQL

This post has been answered by Frank Kulash on Apr 5 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2018
Added on Apr 5 2018
6 comments
2,465 views