Hi guys
Suppose there is a table in MySql database which has two fields of type Date, say startDate and endDate. Now, what's the exact HQL query to retrieve those records whose the difference between start and end date is e.g. 57 days. I have used the subtraction operator (-) but it doesn't work for days whose difference is more than 30 days. My HQL query is something like this:

"from Task task where (task.endDate-task.startDate)=60"

Thanks in advance for any help
-Maysam