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

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 12 2005

Added on Aug 11 2005

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

4 comments

540 views