Is there a way to compare dates using HQL where you can someone string the query together in a string. I know about setParameter but I would like to string together a query purely string


I want to be able to build a filter based on string only

Query summaryQuery = session.createQuery("from DPHeaderVO " + sqlSuffix);

where sqlSuffix would be a list of criteria which has date objects.

sqlSuffix ="where startDate <='somedate'"

You can by using native SQL to do the conversions. Obviously, its not pure HQL thus its not portable across most platforms.

for example Oracle;
sqlSuffix ="where to_char(startDate,'dd/mm/yyyy' <='10/02/2007'"