Skip to Main Content

Analytics Software

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!

Subtracting sysdate from parameter

449962Aug 11 2005 — edited Aug 15 2005
All,
I need to have user input parameter value.
for example i want to restrict query based on input parameter.
I have created a paramter as old_report where user would enter number of days they want to go back and see reports for.
So my where condition is
Receipt_date <=TRUNC(SYDATE)- :Old_report.

whenever i tried to enter value it fails with error wrong value '5' for paramter
Looking at documents it says that it requires same datatype with reserved words.
SYSDATE being reserverd words how do i convert numeric values to date format?

Any one please help.
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2005
Added on Aug 11 2005
4 comments
535 views