[code] create table test_date (creation_date date); [/code] [code] Insert into test_date (CREATION_DATE) Values (TO_DATE('07/14/2017 14:45:10', 'MM/DD/YYYY HH24:MI:SS')); COMMIT; [/code] --My code [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')); [/code] I am comparing dates in my code using the fnd_standard_date valueset. But it is not fetching data. I am passing pv_date ...