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