MySQL DATE_ADD INTERVAL is not working with Hibernate.

Question

My query below, shows hibernate exception:

SELECT DATE_ADD(DATE_FORMAT(MIN(t.time),'%Y-%m-%d'), INTERVAL 6 DAY) FROM Table t;

From what I understand, hibernate doesn't recognize INTERVAL keyword.

Can anyone please help me write an HQL query which gives me the same result as my above query?

(I am trying to get the date post 1 week from the minimum date in my table)

JB Nizet · Accepted Answer · 2012-06-26 09:21:24Z

1

HQL and SQL are two different things. You could use a native SQL query instead of a HQL query. Or you could just execute the following query:

select min(t.time) from SomeEntity e

and add 6 days in Java:

Date minDate = (Date) query.uniqueResult();
minDate = DateUtils.addDays(d, 6); // using apache commons-lang

answered Jun 26, 2012 at 9:21

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

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

2 Comments

rashi mon Over a year ago

I need the result inside my query, because i am using it as a sub-query. I am trying to find some cumulative value of a row in my table only for the first week. So, inside my query there are condition like: date >= min(date) and date <= (a date after 6 days from the min(date))

JB Nizet Over a year ago

Then I'm afraid you'll need to use SQL.

Collectives™ on Stack Overflow

MySQL DATE_ADD INTERVAL is not working with Hibernate.

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related