"datediff" is declared as NoArgSQLFunction in H2Dialect, but actually accepts 3 arguments. ------------------------------------------------------------------------------------------ Key: HHH-2683 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2683 Project: Hibernate3 Issue Type: Bug Components: query-hql Affects Versions: 3.2.4.sp1 Reporter: Dmitry Katsubo The following line in org.hibernate.dialect.H2Dialect registerFunction("datediff", new NoArgSQLFunction("datediff", Hibernate.INTEGER)); should be read as: registerFunction("datediff", new StandardSQLFunction("datediff", Hibernate.INTEGER)); -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira