Hibernate : convert mysql Query Datedif to HQL Query

Question

here is my Query in mysql

SELECT DATEDIFF('2008-11-30','2008-11-29') AS DiffDate

how to convert in to Hibernate Query Language

Damian Leszczyński - Vash · Accepted Answer · 2012-11-09 09:31:34Z

2

One of the way you can achieve this by extending mysql dialect and register it using registerFunction(String, SQLFunction)

public class CustomMySQL5InnoDBDialect extends MySQL5InnoDBDialect {

  public CustomMySQL5InnoDBDialect () {
    super();
    registerFunction( "datediff", new SQLFunctionTemplate( StandardBasicTypes.INTEGER, "datediff(?1, ?2)" ) );
 }

}

edited Nov 9, 2012 at 9:31

Damian Leszczyński - Vash

31k9 gold badges64 silver badges95 bronze badges

answered Nov 9, 2012 at 9:11

Jigar Parekh

6,2937 gold badges46 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jigar Parekh Over a year ago

create above class and update your hibernate configuaration with CustomMySQL5InnoDBDialect instead of MySQL5InnoDBDialect

marc_s · Accepted Answer · 2016-09-21 15:54:05Z

0

I do not think that you could get this specific mysql function into JPA/HQL (you can still use some native query if you want). A better approach would be using a third party library like [Joda-time][1] to compute the number of days between two dates. I do not really see why we should use the database for this.

edited Sep 21, 2016 at 15:54

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Nov 9, 2012 at 9:06

willome

3,17221 silver badges32 bronze badges

Collectives™ on Stack Overflow

Hibernate : convert mysql Query Datedif to HQL Query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related