ORA-01861: Literal does not match format string

when i try to insert same values in sql it is getting inserted. But, when i insert through front end (ASP.NET), i am gettting "ORA-01861: literal does not match format string " error.
what would be the problem.
please help as soon as possible.

select DISTINCT d.VENDOR_NAME,b.INVOICE_ID,a.ATTRIBUTE1,b.INVOICE_AMOUNT,b.INVOICE_NUM,
a.INVOICE_DATE,abs(a.INVOICE_AMOUNT),
f.TAX_NAME,f.SECTION_CODE,f.TAX_RATE,f.TAX_ID,a.ORG_ID,e.TDS_VENDOR_TYPE_LOOKUP_CODE,e.PAN_NO
from
ap_invoices_all a,ap_invoices_all b,JA_IN_TAX_CODES f,ap_invoice_distributions_all c,
po_vendors d,ja_in_vendor_tds_info_hdr e,hr_operating_units g
where
to_number(a.ATTRIBUTE1)=b.INVOICE_ID
and to_number(c.ATTRIBUTE1)=f.TAX_ID
and b.INVOICE_ID=c.INVOICE_ID
and c.INVOICE_ID=to_number(a.ATTRIBUTE1)
and a.VENDOR_ID=d.VENDOR_ID
and b.VENDOR_ID=d.VENDOR_ID
and a.ATTRIBUTE1where to_number ( a.ATTRIBUTE1 ) = b.INVOICE_ID and to_number ( c.ATTRIBUTE1 ) = f.TAX_ID and b.INVOICE_ID = c.INVOICE_ID and c.INVOICE_ID = to_number ( a.ATTRIBUTE1 ) and a.VENDOR_ID = d.VENDOR_ID and b.VENDOR_ID = d.VENDOR_ID and a.ATTRIBUTE1 is not null
--a.ORG_ID=e.ORGANIZATION_ID and
and g.ORGANIZATION_ID =:Name
--and to_char(a.INVOICE_DATE,'DD-MON-RRRR')
and to_date(a.INVOICE_DATE,'DD-MON-RRRR')
between to_date(:From_date ,'DD-MON-RRRR')and to_date(:To_date,'DD-MON-RRRR')
and d.VENDOR_ID=e.VENDOR_ID
and f.Section_code like :SectionCode
and e.TDS_VENDOR_TYPE_LOOKUP_CODE Like :Vendor_Type
and a.SOURCE like 'TDS'
and a.INVOICE_TYPE_LOOKUP_CODE like 'CREDIT'


when m runing in toad i am not getting any kind of error.
but m registering with the oracle then m running it,it is throwing me a error..
please help me out with this problem..
thanks & regards

Sunil

when i m runing in toad i am not getting any kind of error.

But when i am executing through the ASP page it is showing me this error. I tried changing the datefromat but same error i am facing .. could anyone solve this issue or tell me the solution.

I am attaching the query:


SELECT dlvdt, brcode, COUNT (dlvcnno) totaldlv_cnt,
COUNT (pod_cnno) podcnno_cnt,
(COUNT (dlvcnno) - COUNT (pod_cnno)) notpodmf_cnt, COUNT (day0) day0,
COUNT (day2) day2, COUNT (day3) day3, COUNT (day4) day4,
COUNT (day_more4) day_more4
FROM (SELECT cnno dlvcnno, pidmfd_podno pod_cnno, brcode,
TO_CHAR (pidmfd_date, 'DD-MM-YY') podmfdt, dlvdt,
CASE
WHEN ( TO_DATE (pidmfd_date, 'DD-MM-YY')
- TO_DATE (dlvdt, 'DD-MM-YY')
) = 0
THEN '1'
END day0,
CASE
WHEN ( TO_DATE (pidmfd_date, 'DD-MM-YY')
- TO_DATE (dlvdt, 'DD-MM-YY')
) = 1
THEN '1'
END day2,
CASE
WHEN ( TO_DATE (pidmfd_date, 'DD-MM-YY')
- TO_DATE (dlvdt, 'DD-MM-YY')
) = 2
THEN '1'
END day3,
CASE
WHEN ( TO_DATE (pidmfd_date, 'DD-MM-YY')
- TO_DATE (dlvdt, 'DD-MM-YY')
) = 3
THEN '1'
END day4,
CASE
WHEN ( TO_DATE (pidmfd_date, 'DD-MM-YY')
- TO_DATE (dlvdt, 'DD-MM-YY')
) > 3
THEN '1'
END day_more4
FROM (SELECT fdmd_cnno cnno, fdmd_bocode brcode,
TO_CHAR (fdmd_date, 'DD-MM-YYYY') dlvdt
FROM fdm_dtl
WHERE fdmd_bocode IN ('B16', 'B07', 'B11')
AND ( (fdmd_cnno LIKE 'D%')
OR (fdmd_cnno LIKE 'V%')
OR (fdmd_cnno LIKE 'N%')
OR (fdmd_cnno LIKE 'F%')
OR (fdmd_cnno LIKE 'W%')
)
AND fdmd_date BETWEEN TO_DATE ('02-06-2009',
'DD-MM-YYYY')
AND TO_DATE ('04-06-2009',
'DD-MM-YYYY')
AND fdmd_del_status = 'D'
UNION ALL
SELECT drsd_cnno cnno, drsd_brcode brcode,
TO_CHAR (drsd_date, 'DD-MM-YYYY') dlvdt
FROM drs_dtl
WHERE drsd_brcode IN ('B16', 'B07', 'B11')
AND ( (drsd_cnno LIKE 'D%')
OR (drsd_cnno LIKE 'V%')
OR (drsd_cnno LIKE 'N%')
OR (drsd_cnno LIKE 'F%')
OR (drsd_cnno LIKE 'W%')
)
AND drsd_date BETWEEN TO_DATE ('02-06-2009',
'DD-MM-YYYY')
AND TO_DATE ('04-06-2009',
'DD-MM-YYYY')
AND drsd_del_status = 'D') a,
pod_delmf_dtl
WHERE cnno = pidmfd_podno(+) AND brcode = pidmfd_disp_brcode(+))
GROUP BY dlvdt, brcode
ORDER BY brcode, dlvdt

Please note it is running fine in toad but not running through asp

Thanks In Advance

Hi every body,

Whoever is facing such probelm can play around with the following code below it works.. My problem is solved when coverting the date in the format below. first converting to character and then to date.

TO_DATE (TO_CHAR (pidmfd_date, 'DD-MM-YY'),'DD-MM-YY')

enjoy