DateDiff in sleep mode

Question

How to use Datediff (MySQL) in Hibernate?

Answer 1

maybe this might help: https://forum.hibernate.org/viewtopic.php?p=2393545

Answer 2

It’s better to realize your own dialect. Something like that

import org.hibernate.dialect.SQLServerDialect; import org.hibernate.dialect.function.VarArgsSQLFunction; import org.hibernate.type.StandardBasicTypes; public class MsSqlDialect extends SQLServerDialect { public MsSqlDialect() { super(); registerFunction("DATEDIFF", new VarArgsSQLFunction(StandardBasicTypes.INTEGER, "dateDiff(", ",", ")")); } }