Hi,

I try to write a HQL query having date operations like:

from t_table where date_col1 > date_col2 + 8days

At first I tried to change 8days in ms but the results were not those expected.

Then I tried to create a Calendar instance initialized with 8days in ms (wich equals approx 08/01/1970) and to bind it to the query with query.setCalendar(0,<myCalVar>), but, once again, the results were not those expected.

So, my last chance before switching to use SQL proprietary to my DBMS functions is to asking help...

Thanks