0

Can someone help me to implement the following query in JPA.

select * from Location where create_Tmstp < sysdate - 10;

It actually throwing the following error while converting this.

Exception Description: Syntax error parsing [select l from Location l where l.createTmstp < (CURRENT_TIME - 100) ]. The left expression is not an arithmetic expression.

Gopikrishna Mandapati
  • 49
  • 5
  • possible duplicate of [Java: JPQL date function to add a time period to another date](http://stackoverflow.com/questions/2856386/java-jpql-date-function-to-add-a-time-period-to-another-date) – Alan Hay Nov 19 '14 at 14:12
  • current_time - 100 ? 100 what? seconds, millisecs, hours ? – Neil Stockton Nov 19 '14 at 15:33

0 Answers0