how to find difference between two timestamp using hibernate query language

Question

I am trying to write an hql query which gives me the number of hours between two timestamp.

So, far i am unable to do this. I have used hql hour function but that does not work if the

timestamp corresponds to different date. Please provide any input.

My hql query is

select count(*) from com.xxx.Request as request where   request.id = :id and hour(current_timestamp - request.lastEventDate) > :delay

Maurice Perry · Accepted Answer · 2010-04-13 06:05:50Z

5

well, you can use:

days(first_timestamp) * 24  + hours(first_timestamp)
     - days(second_timestamp) * 24 - hours(second_timestamp);

Maurice Perry

32.8k9 gold badges72 silver badges97 bronze badges

answered Apr 13, 2010 at 5:41

Bozho

599k147 gold badges1.1k silver badges1.2k bronze badges

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

1 Comment

This won't work if the dates being compared belong to different months