我可以帮你将一些SQL转换为Hibernate SQL。
SQL:
String sql = "select time, hour(time) as hour, minute(time) as minute "
+ "from db where time >= DATE_ADD(now(), INTERVAL -24 HOUR) "
+ "group by 2 order by time LIMIT 500";
我使用SQLQuery添加标量。我尝试了以下HQL代码:
String hql = "select time, hour(time), minute(time) from db as O "
+ "where O.time >= :time group by 2 order by O.time";
Query query = session.createQuery(hql);
query.setDate("time", calend.getTime()); //calend is a Calendar object
然而,这并不起作用。错误显示它是hql错误。
GROUP BY hour(time)
看看是否有帮助。 - knittl