Best way of converting Oracle SQL query to JPA JPQL BETWEEN DATE/TIME
Published in 2018-02-09 18:17:06Z
I am trying to run this SQL statement that finds a created entry between 6AM today to 6AM the next day. However I am having trouble finding a way of doing this with JPA JPQL. Any info will help, thanks.
SELECT * FROM OTHER_ENTRY WHERE CREATED_DT
trunc(current_timestamp) + interval '6' hour
trunc(current_timestamp + 1)+ interval '6' hour;