Using INTERVAL in hibernate

public class Dialect extends MySQLInnoDBDialect {

public Dialect() {
super();
registerFunction( "date_add_interval", new SQLFunctionTemplate( Hibernate.DATE, "date_add(?1, INTERVAL ?2 ?3)" ) );
}

}


Modified HQL
allotment.date >= DATE_FORMAT( date_add_interval(:currentDateTime, supplier_leadtimes, HOUR), '%Y-%m-%d')