How to work with date in Named query

cfogaca · **Joined:** Mon Jun 06, 2005 8:53 am **Posts:** 16

Hi,

How can I do this SQL statement using a HQL (named query)?

select * from mytable
where
date(mydate) > date(current date) and
date(mydate) < date(current date) + 60 days;

If I insert the date() I get an error on the named query when I start the server.

Any idea?

Thanks,
Cristiane

kochcp · **Posted:** Thu Sep 08, 2005 2:59 pm

to set today's date, use the Query class's setters for named parameters and just write some named parameters into your query

Code:

Query q = session.getNamedQuery("myquery");
q.setParameter("todaysdate", todaysDate);