How compare localdatetime

[SShahmuradli]

Hi! i try to select data where localdatetime field(createdOn) match to period between to 2 localdatetimes

what i try to do, but it does not work.

 public List<Somedata> findsomedata() {


      var sixtyDays = LocalDateTime.now().minusDays(60);    
       var query = persistence.createCriteriaBuilder(Somedata.class);
        return query.where(Fields.createdOn)
            .betweenExpression(String.valueOf(sixtyDays)).andExpression(String.valueOf(sixtyDays.minusHours(3)))
            .getResultList();
    } 
    

How can i solve it? Thanks in advance!

[beikov]

You can use the following:

return query.where(Fields.createdOn)
        .between(sixtyDays).and(sixtyDays.minusHours(3))
        .getResultList();

Note that betweenExpression and andExpression expect a JPQL expression, but what you want to pass here is an actual value.

[SShahmuradli]

i have it in application.properties quarkus.hibernate-orm.jdbc.timezone=UTC

[SShahmuradli]

did not configure anything in JVM

[beikov]

anyway i run app and db in my local machine and there should not be problem with timezone, right?

You have to configure the JVM system property user.timezone=UTC, otherwise the JDBC driver might do funky things. Also see https://stackoverflow.com/questions/59896136/how-to-set-timezone-in-quarkus-to-utc

[SShahmuradli]

thanks. It was UTC problem. for local testing took into account the time zone)

[beikov]

Time zones are hard. The best run into issues with them ;)