Best way of converting Oracle SQL query to JPA JPQL BETWEEN DATE/TIME
user457 Published in May 23, 2018, 8:07 pm
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;