title: Time comparison in JPQL for Oracle
body: <p>I want to select last 15 minutes record from DB with JPQL, my Named Query is</p>
  
  <pre><code>@NamedQuery(
    name="Request.Select", 
    query="SELECT b FROM EVCRequest b  WHERE b.timein &gt; :timein")
  </code></pre>
  
  <p>And I query like following</p>
  
  <pre><code>Query query = em.createNamedQuery("Request.Select");
  query.setParameter("timein", new Timestamp(System.currentTimeMillis() - 900000));
  </code></pre>
  
  <p>But its not providing expected results</p>
  
  <p>In database date format is</p>
  
  <pre><code>"dd-MMM-yy hh:mm:ss aa"
  </code></pre>