ORA-01843: not a valid month

[premkumark]

Hi, 
 
I am getting the following error when i try to run a report with date parameter. 
 
The report was created using jasper reports and the database is Oracle 10g. 
 
i am using the following query in the report.. 
 
SELECT ANALYSIS_NAME, ANALYSIS_RESULT FROM ANALYSIS WHERE RECEIVED_DATE =  
TO_DATE($P{START_DATE}, MM/DD/YYYY) 
 
I ran this query in TOAD its working fine but when i run the report its throwing an error saying "ORA-01843: not a valid month" 
 
Thanks, 
Kumar 
 

[singhipst]

HI,

 

Please check again your query is not correct. It soule be

 

SELECT ANALYSIS_NAME, ANALYSIS_RESULT FROM ANALYSIS WHERE RECEIVED_DATE =  
TO_DATE($P{START_DATE}, 'MM/DD/YYYY')

 

 

also verfy the parameter. May be problem with qouts which is required in the query.

[premkumark]

Hi,

 

sorry i missed the quote while typing in the forum, but the qoute is present in my work code.

 

thanks,

kumar