Hi all!
I'm desperately trying to execute a query which has in its WHERE condition a Date field.

Since the Date field contains dd/mm/yyyy hh:mm:ss I need to issue a trunc:
this is the exact SQL that works from Sql plus:



This is my EJB QL query:



but this issues a "Caused by: java.sql.SQLException: ORA-01861: literal does not match format string"



Still the same problem.....:-(

I'm using Entity Beans 3.0 JPA (JBoss Application server). Unfortunately I couldn't find anything on EJB 3.0 related documents so I'm looking here for help.....

thanks alot
frank

I think the date format setting is different while executing via SQL Plus and executing via Hibernate. Try setting the date

alter session set nls_date_format=<format you want> and then execute the other Query.

Hope this helps,
Latha.

The select you want to execute is:


SELECT taskId from TaskList WHERE to_char(BEGIN_DATE,'dd/mm/yyyy')= '01/01/2004'

Thanks a lot ! to_char was the right function !
regards
frank