Get Started with Redwood for Oracle Cloud HCM Begin Now
SQL Query it has to pick start date and end date automatically
Summary
SQL Query it has to pick start date and end date automaticallyContent
Hi Team,
I have an requirement where start date and end date has to pick automatically.
In sql query i have an parameters start_date and end_date. These parameters has to pick automatically.
For an example, If i run this month(May) start date should be March 20th and End_date should be April 20th.
By using default value in the parameter we can do this but, If use default value in some months we have 30 days. In some months we have 31 days. Date will chage.
1