mysql - Converting SQL query to Hibernate query -

i need converting sql hibernate sql.

sql:

string sql = "select time, hour(time) hour, minute(time) minute "            + "from db time >= date_add(now(), interval -24 hour) "            + "group 2 order time limit 500"; 

i use sqlquery add scalars. tried hql:

string hql = "select time, hour(time), minute(time) db o "            + "where o.time >= :time group 2 order o.time";  query query = session.createquery(hql); query.setdate("time", calend.gettime()); //calend calendar object 

however, doesn't work. error says it's hql error.

instead of using setdate try using setparameter.

from this link hql dates:

"setdate" truncate hql date value , ignore hours, minutes, seconds.

using setparameter interpret values parameter indicated :variable.