Hi there

After playing a while around with Hibernate, I have a few
issues. Apart from that, it's a quite nice and easy-to-use tool,
the code-compile-test cycle is much shorter than usual!

I have a class containing a java.util.Date-Object, this
will be mapped to a DATETIME on my MySQL DB (4.0.14).
(Hibernate 2.0.3, Java 1.4.2)

Now the problem is: How can I compare 2 Dates ?


I tried it like:

But this always returns 0 results... (Yes, I have a few entries
for todays date ;))

The problem is that also the times will be compared... How can I avoid
this behaviour, because I'm only interested in the Date (Year, Month,
Day) ? Is there an easy solution for MySQL, or do I something wrong ?

Thanks in advance
"L

Don't you mean to map this with type="date"?

If not, your database should have some function to truncate the datetime to a date. You may call this function in the HQL where clause. Then use Hibernate.DATE to bind the parameter, just like you did.

Thanks for your fast and helpful response.

After adding the type="date" property to the XDoclet
comment it worked perfectly! The DB-Schema changed slightly
(from DATETIME to DATE) and even the query returned some
rows.

Great!

Thanks a lot
"L