Hi,

I am performing a report query with date comparison, I saw lots of examples with the date generated by Java, but I have to compare two date fields in database, not only so but I need to compare even the difference between them, something like:

I did a SQL which works but I couldn't figure it out with HQL, I hope I be able to do that because the database engine may change, and HQL keeps it working even so.

Thanks!