[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 = ’14-JUL-2017′.

Can anyone please help.