Guest User

Untitled

a guest
Jan 20th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. Path<Date> accountCreatedTime = root.<Date> get("AccountCreatedTime");
  2. Path<Date> firstPostCreatedTime = root.<Date> get("FirstPostCreatedTime");
  3.  
  4. final Predicate timeInHourPredicate = criteriaBuilder
  5. .greaterThanOrEqualTo(accountCreatedTime, FirstPostCreatedTime);
  6.  
  7. select u
  8. from users u
  9. join posts p on p.user_id = u.id
  10. where datediff('hour', u.account_created_time, p.first_post_created_time)
Add Comment
Please, Sign In to add comment