ejb3 question, Compare date only for a TIMESTAMP field?

liudan2005 Jun 20, 2006 5:22 AM

I know it's a wrong place to post it here but still worth a try since i can't get answer from ejb3 forum.

I have a date field defined as Temporal.TIMESTAMP. There seem to be a problem If I want to compare its date without check time. Here is my hql:
em.createQuery("from A a where a.datetime=:date").setParameter("date",new Date(),Temporal.DATE);

This fails unless I define my date filed as Temporal.DATE. As I need both time and date mostly, i have to define it as Temporal.TIMESTAMP. Is there anyway to achive this in ejb ql?

1. Re: ejb3 question, Compare date only for a TIMESTAMP field?

gavin.king Jun 20, 2006 6:34 AM (in response to liudan2005)
There is no good way to do this within the EJB3 spec unfortunately.

In Hibernate, the following should work:

from A a where day(a.datetime) = :day and month(a.datetime) = :month and year(a.datetime) = :year

On a lot of databases, the following will also work:

from A a where date(a.datetime) = :date
Actions
2. Re: ejb3 question, Compare date only for a TIMESTAMP field?

liudan2005 Jun 20, 2006 4:31 PM (in response to liudan2005)

Thanks Gavin. Problem solved.
Actions

Go to original post