hi. i'm having a problem trying to pass in parameters to sql functions. see below:

StringBuffer sb = new StringBuffer("SELECT lastName from myDB where dateAdded <= TO_TIMESTAMP_TZ(:dateAdded, 'DY MON DD HH24:MI:SS TZD YYYY')");

Query myquery = sessionFactory.getCurrentSession().createQuery(sb.toString());

myquery.setDate("dateAdded", dateAdded);

after checking the logs, i'll get org.hibernate.exception.SQLGrammarException: could not execute query. But, if i remove the TO_TIMESTAMP_TZ function and just do "dateAdded <= :dateAdded" that'll work fine. Do you know how i can fix this? thanks

TO_TIMESTAMP_TZ converts char of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to a value of TIMESTAMP WITH TIME ZONE datatype.

you are entering a date as a parameter to this function

to make your code work say something like



Regards