ORA-01481 invalid number format model
554924Apr 23 2012 — edited Apr 24 2012Dear All,
I am getting below error when i am running the below query Please help me
SELECT *
FROM dual
where TO_CHAR(sysdate, 'DD/MM/YYYY') >= TO_CHAR(&P_FROM_REG_DATE, 'DD/MM/YYYY')
value a:- 14/04/2012
Error:-
ORA-01481 invalid number format model
Edited by: YKING on Apr 23, 2012 6:35 PM