title: converting mysql query into spring JPA query
body: <p>I have the following mysql query that I want to convert to SPring JPA.</p>
  
  <pre><code>SELECT * FROM SERVER s WHERE s.COMPLETE_DT BETWEEN (DATE_SUB('2014-11-07 16:30:20', INTERVAL 20 MINUTE)) 
  AND (DATE_SUB('2014-11-07 16:30:20', INTERVAL 10 MINUTE)) 
  </code></pre>
  
  <p>I am doing it the following way </p>
  
  <pre><code>@Query("SELECT s FROM Server s WHERE s.completeDt BETWEEN (DATE_SUB(%?1%, INTERVAL 20 MINUTE)) AND (DATE_SUB(%?1%, INTERVAL 10 MINUTE)))
  List&lt;Server&gt; findDate(Date dt);
  </code></pre>
  
  <p>but getting an error </p>
  
  <blockquote>
    <p>"Interval" not recognized</p>
  </blockquote>