Can anyone please tell whether HQL support any specific date functions or something.

I need to check for transactions between a date range (that can be done) and the document expiration date is greater than or equal to the transaction month. The document expiration date is a date column for eg., 11/01/2004, if this is the expiration date, the document expires at the end of the month (we cannot change the date, gotta use it this way). this only, I need to select transaction for a month, whose transaction date falls within the expiry period. basically I have to select like this.

trans.date between :startDate and :endDate
document.expirationDate's year value >= transaction startDate year document.expirationDate's month value >= transaction Start Date month like that. (how to do this?)

if you can give examples that would be great.

Kinda need this ASAP.

Can you please advice how to do date manipulations using HQL ?

Thanks a lot
SRK

All database-specific sql functions are just passed through by Hibernate, just use your normal old date functions like in SQL

Thanks a lot. will do so.

Is it possible to use date sql functions in a portable way (working across different SQL servers)?

I was wondering about externalizing such DB dependent SQL queries with incompatibile date functions using named queries in mapping files, but I have not found any possibility to write different queries for different DB dialects.

Am I missing something?

Regards,
Karel