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!

adding days to date(integer format)

2886750Feb 19 2015 — edited Feb 19 2015

Hello All,

I'm trying to add  days to a date which is in numbers.

Suppose i have a date 20140331 and if i add +1 to it i would get 20140332. How can i get 20140401 in number format using pl/sql query.

Also i should be able to add any number of days to the existing dates to get the right date. The above example is just a sample.

Thanks
This post has been answered by Frank Kulash on Feb 19 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2015
Added on Feb 19 2015
5 comments
1,288 views