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

2 votes134 views2 answers
Image rendering values css
CSS
1 vote136 views1 answer
Css %-px
CSS
1 vote132 views2 answers
Border for text in html
CSS
0 vote137 views1 answer
Tailwindcss init full
CSS
2 votes128 views1 answer
How to make animation stay on 100%
CSS
0 vote144 views1 answer
Repeating-conic-gradient css
CSS
1 vote166 views1 answer
How to put something on layers css
CSS
21 votes129 views2 answers
How to write css for input type text
CSS
3 votes130 views2 answers
Form css
CSS
0 vote130 views1 answer
Añadir hojas css externas a wordpress
CSS