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 i have the following query geting this error ORA-01861: literal does not match format string
select count(*) from EMPLOYEE l WHERE l.HIRE_date > nvl(l.HIRE_date,'2002/03/31');
select count(*)
from EMPLOYEE l
WHERE l.HIRE_date > nvl(l.HIRE_date,'2002/03/31');
am in database 11gR2
DATA TYPE IS
HIRE_date DATE