1

I want to get all records in last 24h in HQL.

In sql I know that I can get like this:

select * from acc where created BETWEEN NOW() - INTERVAL '24 HOURS' AND NOW()

But in HQL, INTERVAL is not supported. Any suggestion how can I achieve this?

Basil Bourque
  • 303,325
  • 100
  • 852
  • 1,154
None
  • 8,817
  • 26
  • 96
  • 171
  • See: https://stackoverflow.com/a/46080928/14756421 – Maxim Bezmen Mar 21 '22 at 11:59
  • Please take more care in your typing and spelling. This site is meant to be a formal knowledge base, more like Wikipedia, less like a casual chat room. I did some editing for you this time. – Basil Bourque Mar 21 '22 at 15:07

0 Answers0