title: JPA Query MONTH/YEAR functions
body: <p>How can I write a JPA query using <code>MONTH</code> function just like sql query?</p>
  
  <pre><code>@NamedQuery(name="querybymonth", query="select t from table1 t where MONTH(c_Date) = 5")
  </code></pre>
  
  <p>When I use the above pattern for query, I get an error: <code>unexpected token - MONTH</code>.</p>