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!

Getting the last date of the previous month

PSULionRPJul 7 2009 — edited Jul 7 2009
I have a situation in which I need to retrieve the last day of the previous month to see if something falls within that Billing Cycle. I am dealing with an Oracle 9i Environment; Version 9.2.0.8.0. I have done a little research and see that there is an "ADD_MONTHS" function. But no such thing as "SUBTRACT_MONTHS" function. Is there any way to get the last day of the previous month?

Thanks in advance for your review and help.

PSULionRP
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2009
Added on Jul 7 2009
11 comments
20,855 views