Skip to content

Instantly share code, notes, and snippets.

@revseev

revseev/DB timestamp query

Created April 5, 2020 16:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save revseev/1c0bcfd8ccd6f985df479cc641f8ce11 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save revseev/1c0bcfd8ccd6f985df479cc641f8ce11 to your computer and use it in GitHub Desktop.
Download ZIP
JPQL Timestamp query
Raw
DB timestamp query
@Override
public List<Song> getByCreatedDateRange(Timestamp dateFrom, Timestamp dateTo) {
return entityManager
.createQuery("FROM Song s WHERE s.createdAt >= :dateFrom AND s.createdAt <= :dateTo ORDER BY s.createdAt", Song.class)
.setParameter("dateFrom", dateFrom)
.setParameter("dateTo", dateTo).getResultList();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment