Performing Date/Time Math In HQL?

by

Why do you need to do it in the query? Why not just handle it in the java code.

for example:

From RandomThing
Where randomTime is not null and
      randomTime >= :currentTimestamp and
      randomTime <= :maxTimestamp

And then just set the parameters.

More Related Contents:

  1. How do you create a Distinct query in HQL
  2. how to return Map with HQL
  3. Date operations in HQL
  4. New object with HQL
  5. How to simulate NVL in HQL
  6. Mapping many-to-many association table with extra column(s)
  7. What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate
  8. JPA and Hibernate – Criteria vs. JPQL or HQL
  9. What is the difference between DAO and Repository patterns?
  10. How to query data for Primefaces dataTable using lazy loading and pagination
  11. Hibernate Search: How to use wildcards correctly?
  12. Struggling to understand EntityManager proper use
  13. java.lang.ClassNotFoundException: org.hibernate.HibernateException
  14. Hibernate problem – “Use of @OneToMany or @ManyToMany targeting an unmapped class”
  15. How to use the Java 8 LocalDateTime with JPA and Hibernate
  16. Hibernate throws org.hibernate.AnnotationException: No identifier specified for entity: com..domain.idea.MAE_MFEView
  17. Using JPA entities in JSF. Which is the best strategy to prevent LazyInitializationException?
  18. Hibernate field naming issue with Spring Boot (naming strategy)
  19. Hibernate: How specify custom sequence generator class name using annotations?
  20. Deleted object would be re-saved by cascade (remove deleted object from associations)
  21. what is the right path to refer a jar file in jpa persistence.xml in a web app?
  22. JPA CriteriaBuilder – How to use “IN” comparison operator
  23. Setting properties programmatically in Hibernate
  24. When to Use EntityManager.clear()?
  25. HQL left join of un-related entities
  26. Hibernate unidirectional one to many association – why is a join table better?
  27. What is the right way to use spring MVC with Hibernate in DAO, service layer architecture
  28. hibernate – get id after save object
  29. How to write a like query in HQL
  30. UnsupportedOperationException: The application must supply JDBC connections

Leave a Comment