Check date between two other dates spring data jpa

by

You should take a look the reference documentation. It’s well explained.

In your case, I think you cannot use between because you need to pass two parameters

Between – findByStartDateBetween … where x.startDate between ?1 and ?2

In your case take a look to use a combination of LessThan or LessThanEqual with GreaterThan or GreaterThanEqual

  • LessThan/LessThanEqual

LessThan – findByEndLessThan … where x.start< ?1

LessThanEqual findByEndLessThanEqual … where x.start <= ?1

  • GreaterThan/GreaterThanEqual

GreaterThan – findByStartGreaterThan … where x.end> ?1

GreaterThanEqual – findByStartGreaterThanEqual … where x.end>= ?1

You can use the operator And and Or to combine both.

More Related Contents:

  1. Dynamic spring data jpa repository query with arbitrary AND clauses
  2. setMaxResults for Spring-Data-JPA annotation?
  3. Spring Data JPA – ZonedDateTime format for json serialization
  4. How does the FetchMode work in Spring Data JPA
  5. Handling soft-deletes with Spring JPA
  6. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  7. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  8. JPA: update only specific fields
  9. Spring-Data FETCH JOIN with Paging is not working
  10. Why use returned instance after save() on Spring Data JPA Repository?
  11. Spring JpaRepository – Detach and Attach entity
  12. Use abstract super class as parameter for Spring data repository
  13. How to replace table name with parameter value while using Spring Data JPA nativeQuery
  14. How to use @Transactional with Spring Data?
  15. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  16. spring data jpa @query and pageable
  17. Lombok @Builder and JPA Default constructor
  18. JPQL Like Case Insensitive
  19. Spring Data JPA: query ManyToMany
  20. Encoded password does not look like BCrypt
  21. How to store @Query sql in external file for CrudRepository?
  22. Spring Data JPA find by embedded object property
  23. Spring Data JPA findOne() change to Optional how to use this?
  24. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  25. Autowiring fails: Not an managed Type
  26. Spring JPA native query with Projection gives “ConverterNotFoundException”
  27. Spring Data + JPA with multiple datasources but only one set of Repositories
  28. How to instrument / advice a Spring Data (JPA) repository?
  29. Spring Data JPA – Is it possible to sort on a calculated property?
  30. Externalize query in spring boot application

Leave a Comment