How to perform date operations in hibernate HQL -

I want to do data time operations using Hibernate HQL.

I want to add or subtract two dates and also I want to reduce 1 year or 1 month from a particular date.

How is it possible to use HQL in hibernate?

Does anyone know about this?

Is there a tutorial available for this?

Please help.

Thank you.

To use Custom SQL you should write your hibernate bid and register:

  registerFunction ("Day of the week", New SQL Function Template (Hibernate Integir, "to_char (? 1, '' D ')");