I have a Spring boot 1.4.x application that uses the starter jpa in combination with H2/Postgresql. I have an entity that stores a date as an Instant (with Instant.now(), based on Java 8: What's the difference between Instant and LocalDateTime? answer), and the associated table stores this field as a timestamp.
For the storing to work I had to setup a converter that converts Instant's to sql.Timestamps & vice versa, which seems to work (Timestamp.from(instant) and timestamp.toInstant())
My question is if there is a straightforward way to query by Date only using this instant using JPA repository, eg.
List<Orders> findBySaleTime(.... day)
Or am I forced to find a way to convert the day to two instants & do an in between query?