For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi all,
I am passing date as "17-NOV-09"
SELECT history_id
FROM table
WHERE TO_char (creation_date, 'DD-MON-YY') =TO_CHAR (:date1, 'DD-MON-YY');
But getting frm-40735 unhandled exception ora-01403