Oracle9Dialect registers a "lastday" function, but the Oracle function is actually "last_day" (with the underscore). HQL doesn't like "last_day" as it stands, and I get a SQL error if I use "lastday" in HQL, which makes sense. I am using Hibernate 3.1.2 but it looks like the problem is in current CVS as well.

Also... is there a reason SybaseDialect does not register the datediff function? I was able to do that with a custom subclass but it would seem to be useful to have that in SybaseDialect directly. I think SQL Server supports it as well. Not sure about Sybase Anywhere though... maybe that's the reason ;-)

Create a JIRA entry for it (with a patch even though its a simple change).

Okay, I created HHH-2016 with the Oracle problem.

Should I create a separate JIRA request to add datediff() to SybaseDialect, or is there a reason why it hasn't been added before now?

Thanks :-)

The same applies. The easier you make for the team to do the more likely it will occur.