3 Replies Latest reply on Mar 24, 2018 7:54 PM by Vasudeva Veeragandham

    Need urgent help to crack the Paramter

    Vasudeva Veeragandham

      Hi

       

      Need urgent help to crack the below code , Need to split the date parameters into Year (YYYY), Month (Janaury),Day(1).

       

      revenue_timestamp >= to_DATE(DECODE(:P_YEAR, null, '2001', :P_YEAR)

                || '-' || DECODE(:P_MONTH, null, '01', :P_MONTH)

                || '-' || DECODE(:P_DAY, null, '01', :P_DAY), 'YYYY-MM-dd')

      rb.revenue_timestamp < add_months(to_DATE(DECODE(:P_YEAR, null, '2001', :P_YEAR)

                || '-' || DECODE(:P_MONTH, null, '01', :P_MONTH)

                || '-' || DECODE(:P_DAY, null, '01', :P_DAY), 'YYYY-MM-dd'), 1)

       

      Please help me to resolve .