ERROR: ORA-01861: literal does not match format string
776189Oct 6 2010 — edited Oct 6 2010Hi,
i have one function with return the date
declare
v_date date;
begin
select get_comp_date
into v_date
from dual;
i run this code on one remote server which install oracle client 10g
which return date in the format of 'YYYY-DD-MM' hence its fail with ERROR: ORA-01861: literal does not match format string
but when i run same code with other remote server its working fine with date format 'DD-Mon-YYYY'
as per my analyasis there some date setting required in server.
so anybody tell me which setting is need to change to resolve this error.
regards,
Madan