Check date between two other dates spring data jpa

Question

I have this model   public class Event       private String name      private Date start      private Date end      and repository as   Repository public interface EventRepository extends JpaRepository lt Event  Long gt        List lt Event gt  findByEventTypeAccount Account account       What I want to do is  I will pass one date and need to check that date is between start and end eg i will pass sept 30 as date and need to find all entries which have sept 30 between their start and end   Something like findDateisBetweenStartAndEnd Date date

User · Accepted Answer

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.

User · Answer

You can also write a custom query using  Query   Query value    from EntityClassTable t where yourDate BETWEEN  startDate AND  endDate   public List lt EntityClassTable gt  getAllBetweenDates  Param  startDate  Date startDate  Param  endDate  Date endDate

User · Answer

I did use following solution to this    findAllByStartDateLessThanEqualAndEndDateGreaterThanEqual OffsetDateTime endDate  OffsetDateTime startDate

User · Answer

Maybe you could try List lt Article gt  findAllByPublicationDate Date publicationDate   The detail could be checked in this article  https   www baeldung com spring-data-jpa-query-by-date

[java] Check date between two other dates spring data jpa

Examples related to java

Examples related to spring

Examples related to spring-data-jpa

Examples related to spring-repositories