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!

Add one day to the current date

User_DT8TOMay 24 2012 — edited May 24 2012
Hi all,

A stupid question...

How can I add one day to the current date in a select. I want something similar to add one month to current date, but with days:

something like:

select TO_CHAR (ADD_MONTHS (SYSDATE, -1), 'DD-MM-YYYY')
from dual

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2012
Added on May 24 2012
3 comments
1,106 views