Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I specify a default value of “SYSDATE” (the current date) for a report parameter?

April 26, 2017Default parameter report specify sysdate value

0

Posted

Can I specify a default value of “SYSDATE” (the current date) for a report parameter?

1 Answer

0

Posted

Yes. In the “Parameter Setting” screen, you can set the default value for a bind variable as #SYSDATE. For example, for the following query set the default value for the :DATE1 parameter as “#SYSDATE”: SELECT * FROM EMP WHERE HIREDATE < :DATE1 You can also use syntax like #SYSDATE - 10 to calculate 10 days before the current date. The "#" character can also be used to prefix PL/SQL functions or other pseudocolumns (such as USER) as default values.