Hello all,

Hibernate version: 3
DB: MySQL5

I need to compare date entered by the user in format yyyy/mm/dd with the date in database.

e.g MY HQL is
select cust.customerName
from customer cust
where cust.expiryDate = '2009/02/21'

This returns me 0 records, as in MySQL cust.expiryDate is '2009-02-21 14:27:02.0'. My problem is I do not know how to convert cust.expiryDate date in user entered date format. With MySQL native statement that would be easy, but I do not know how it works in HQL.

Would anybody help me here?

Regards
intecgmbh

Try to make a date out of it and a criteria (or hql query and query substitution):

---

Calendar cal = Calendar.getInstance();

cal.set( year, month-1, day );

Date expiryDate = cal.getTime();

---

Criteria criteria = session.createCriteria( Customer.class );

criteria.add( Restrictions.eq( "expiryDate ", expiryDate ) );

return criteria.list();

thanks larshelge for your help.

As you suggested, I tried date() function of HQL and that worked for me.

Thanks once again!!!

Regards
intecgmbh