Friends,

I need a help to transform the following query (in sql) to a query criteria in pure, making it independent of the database.

Already tried and tried almost everything, if someone has something that can help me, thanks.

criteria
.add(Restrictions
.sqlRestriction(
"(str(datepart(hour, dt_registro)) +str(datepart(minute, dt_registro))) "
+ "between (str((?))+str((?))) and (str((?))+str((?)))",
new Integer[] { horaInicio, minutoInicio,
horaFim, minutoFim }, new Type[] {
Hibernate.INTEGER,
Hibernate.INTEGER,
Hibernate.INTEGER,
Hibernate.INTEGER }));


*The idea and that a date field in the database has its time within the range suggested.
*I can't do in HQL.

Could you please also provide the SQL query you mention?