Criteria don't support Date?

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Hi everyone:

I want to know if Hibernate Criteria API can be used with java.util.Date. For example, could I use it in the following code?

Code:

List list= session.createCriteria(Person.class)
     .add( Expression.gt("birthday", myBean.getBirthday()) )
     .add( Expression.ge( "createDate", "1982-2-7" ) )
     .addOrder( Order.asc("createDate") )
     .list();

It seems don't work in Hibernate 2.1.6. I don't want to use HQL. If I use Criteria API,how to do it? I mean how to search by Date using Criteria? Thks!

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Oh, sorry for my mistake, it is numberFormat error and Criteria can search by Date. The following code can work well.

Code:

Date d=new Date();
      List list=s.createCriteria(Person.class).add(Expression.ge("create_date",d)).list();

It 's great and convinent API :-)