Skip to Main Content

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!

Add 3 and half Months to a Date?

RoxyrollersAug 10 2015 — edited Aug 10 2015

Hi folks and Happy Monday.

We all know the ADD_MONTHS function adds (or subtracts) number of months but it takes an integer. Is there a way to add 3 and half months to SYSDATE or would I just have to go with 14 weeks (14x7 days)?

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2015
Added on Aug 10 2015
5 comments
1,251 views