Subtracting sysdate from parameter
449962Aug 11 2005 — edited Aug 15 2005All,
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