4 Replies Latest reply on Jul 20, 2017 2:21 PM by John_K

    error when using FND_STANDARD_DATE valueset

    3279317

      create table test_date

      (creation_date date);

       

      Insert into test_date

         (CREATION_DATE)

      Values

         (TO_DATE('07/14/2017 14:45:10', 'MM/DD/YYYY HH24:MI:SS'));

      COMMIT;

       

      --My code

      select * from test_date

      where

      TO_CHAR(creation_date,'DD-MON-YY') = NVL(TO_CHAR (TO_DATE (:pv_date, 'YYYY-MM-DD HH24:MI:SS'), 'DD-MON-YY'),  TO_CHAR(creation_date,'DD-MON-YY'));

       

       

      I am comparing dates in my code using the fnd_standard_date valueset. But it is not fetching data.

      I am passing pv_date = '14-JUL-2017'.

       

      Can anyone please help.