CODEWITHSUNDEEP
oracle-databasejpa
ImranRazaKhan
ImranRazaKhan

Reputation: 2297

Time comparison in JPQL for Oracle

I want to select last 15 minutes record from DB with JPQL, my Named Query is

@NamedQuery(
  name="Request.Select", 
  query="SELECT b FROM EVCRequest b  WHERE b.timein > :timein")

And I query like following

Query query = em.createNamedQuery("Request.Select");
query.setParameter("timein", new Timestamp(System.currentTimeMillis() - 900000));

But its not providing expected results

In database date format is

"dd-MMM-yy hh:mm:ss aa"

Upvotes: 0

Views: 471

Answers (1)

ImranRazaKhan
ImranRazaKhan

Reputation: 2297

I resolved issue by applying native query like following

SELECT * FROM EVCRequest b WHERE b.timein > sysdate-15/1440

Regards,

Upvotes: 1

Related Questions