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<Map<String,Object>> findRegisteredCustomersHistory(@Param("startDate") Date startDate, @Param("endDate") Date endDate);

Source: stackoverflow.com

Similar codes

6 votes213 views6 answers
No module named crypto.cipher
CSS
1 vote242 views1 answer
Which css property is used to change font
CSS
42 votes201 views4 answers
Css center div in page
CSS
1 vote272 views3 answers
Bootstrap table text vertical align center
CSS
2 votes207 views1 answer
Css resize image without distortion
CSS
2 votes207 views1 answer
Vh vs vw css
CSS
0 vote197 views2 answers
Sass if
CSS
0 vote203 views3 answers
Sass color functions
CSS
0 vote190 views1 answer
How to debug datatables
CSS
37 votes217 views6 answers
Overflow in css
CSS