Java Database Connectivity (JDBC)

Announcement

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!

java.sql.SQLException: ORA-01861: literal does not match format string

843854Feb 28 2003 — edited Dec 21 2006

When I use a query
select eqc_id,title from eqc_questions where to_date(sysdate,'dd/MM'yyyy') between to_date(fromdate,'dd/MM/yyyy') and to_date(todate,'dd/MM/yyyy')
in JSP,it is giveing an exception but when I am using the same query in Oracle database,directly, it is working fine.

Here,fromdate & todate are fields in the table.

I need a solution for this very urgently.

Thanx in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2007

Added on Feb 28 2003

#java-database-connectivity-jdbc

5 comments

752 views