package fr.openwide.core.test.querydsl; import org.junit.Test; import com.querydsl.core.types.dsl.Expressions; import com.querydsl.jpa.impl.JPAQuery; import fr.openwide.core.test.AbstractJpaCoreTestCase; import fr.openwide.core.test.business.person.model.Person; import fr.openwide.core.test.business.person.model.QPerson; public class TestQueryDSLSQLConstructs extends AbstractJpaCoreTestCase { @Test public void testInterval() { JPAQuery<Person> query = new JPAQuery<>(getEntityManager()); query.from(QPerson.person).where(Expressions.booleanTemplate("{0} - {1} * interval({2}) < now()", QPerson.person.creationDate, 8, "1 day")); query.fetch(); } }