Diff between 2 dates

[SShahmuradli]

Hello!
how to find all data where the difference between two fields is more than 30 minutes?

public class Pac {

   ....


   @Embedded
   private SomeClass sc;
   }

firstField and secondField are LocalDateTime

 public List<Pac> findbydiff() {
        return persistence.createCriteriaBuilder(Pac.class)
            .where("sc.firstField - sc.secondField").gt(
                Duration.ofMinutes(30))
            .getResultList();
    }
    
    i get 
Caused by: java.lang.IllegalArgumentException: Parameter value [PT30M] did not match expected type [java.time.LocalDateTime (n/a)]```

[beikov]

Hi there. You can use the function minute_diff for this purpose, like this:

     public List<Pac> findbydiff() {
        return persistence.createCriteriaBuilder(Pac.class)
            .where("minute_diff(sc.secondField,sc.firstField)").gt(30)
            .getResultList();
    }

Also see https://persistence.blazebit.com/documentation/1.6/core/manual/en_US/#temporal-diff-functions

[beikov]

Oops, I forgot a closing parenthesis. Corrected the solution.

[SShahmuradli]

yes, thanks a lot!)