HQL query: filtering LocalDateTime property by LocalTime

Question

I have a problem to create a query which gives back all value where time is between two parameter.

How can I get back those works where endTime time part is between the given LocalTime-s?

public class Work {

  private Long id;
  private LocalDateTime endTime;

  //getters setters 
} 

@Query("SELECT new package.dto(w.id) FROM Work w WHERE TIME(w.endTime) BETWEEN :from AND :to)
List<Dto> createDtoList(LocalTime from, LocalTime to);

Answer 1

CAST(endTime AS java.lang.Time)