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

52 votes145 views4 answers
Css cursor pointer hover
CSS
0 vote142 views1 answer
Reduire espace entre ligne css
CSS
47 votes141 views4 answers
Transform
CSS
3 votes154 views1 answer
Add new class in tailwind css
CSS
0 vote198 views1 answer
React bootstrap carousel not working
CSS Bootstrap
48 votes143 views3 answers
Font-size
CSS
4 votes190 views1 answer
Animation-direction property
CSS
0 vote165 views1 answer
Disabled attribute on button still showing click animation safari macos
CSS
5 votes138 views3 answers
Repeat method
CSS
8 votes129 views2 answers
Invert png color css
CSS