Hibernate - compare DateTime field with Restriction.like

Vote count:

0

I have a createDateTime field with Date dataType in my entity class and hibernate generated a column with datetime type in the mysql table. Now, I need to compare createDateTime field with values without seconds. In fact, one user can enter for example 2015-01-01 12:10 in the search field and I want to show the record that has 2015-01-01 12:10:10 crateDateTime as a result. I know this is possible with flat query:

SELECT * FROM table_test WHERE crateDateTime LIKE "2015-01-01 12:10 %"

But I don't know how I can do this via hibernate.

DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm");
data = formatter.parse("2015-01-01 12:10");

//This returned null.
Criterion crtmp = Restrictions.like("createDateTime", data);

//This returned ClassCastException. Because second argument must have "Date" dataType not "String"
Criterion crtmp = Restrictions.like("createDateTime", data + "%");

asked 2 mins ago

hamed

1,706

Hibernate - compare DateTime field with Restriction.like