0 Replies Latest reply: Jul 25, 2012 7:48 AM by 800528 RSS

    what is format of fnd_standard_date

    800528
      hi,


      i know fnd_standard_date is character 'yyyy/mm/dd hh25:mi:ss' when you pass an value to your pl/sql procedure as argument you need to convert to to_date first to procedure

      vice versa

      i want to return to srs request parameter from my function what format i have to give ...

      when i pass it as default value in program parameters while registering concurrent_program ..


      default type sql statment default value :select myfunc(sysdate) from dual

      myfunction has to return in what date format ....


      thanks you ..