CSS: jpa select date format Example


CSS Example: This is the "jpa select date format" Example. compiled from many sources on the internet by SimpleTutorials.org

jpa select date format

//Spring Boot Repository
@Query(value = "SELECT count(ac) as count, function('date_format', max(ac.subscriptionStartDate), '%Y, %m, %d') as date FROM MyTable ac " +
        "WHERE ac.subscriptionStartDate BETWEEN :startDate AND :endDate GROUP BY function('date_format', ac.subscriptionStartDate, '%Y, %m, %d')")
public List> findRegisteredCustomersHistory(@Param("startDate") Date startDate, @Param("endDate") Date endDate);

* Summary: This "jpa select date format" CSS Example is compiled from the internet. If you have any questions, please leave a comment. Thank you!