I need to port a MySql-Query to hibernate. My goal is not to use native queries but in one case I am missing a function to calculate a difference to two dates.

The query subtracts two dates via MySql DATEDIFF (returns difference in days) and compares the result to an integer. I found no Hibernate equivalent to this except using native Sql. Is there an alternative?


Hibernate version:
3.2

Hmmm... I am using Hibernate 3.2.5 and the DATEDIFF function is available in the MySQL dialect.