How can I write a JPA query using MONTH function just like sql query?
@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.
JPA Query MONTH/YEAR functions
Viewed 54451
5 Answers
if your class holds a date type variable, you can use a query like this:
@Query("select m from Movement m where m.id_movement_type.id=1 and SubString(cast(m.date as text),1,4) = :year")
List<Movement> buysForYear(@Param("year") String year);
Related