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

0 vote200 views1 answer
How to center an overlay button using flex box
CSS
1 vote192 views2 answers
Css div side rounded
CSS
38 votes211 views3 answers
Cool ways to color a background with css
CSS
0 vote197 views1 answer
Two background images css
CSS
0 vote222 views1 answer
Width height samsung note 20 screen
CSS
9 votes194 views2 answers
Align items in row css
CSS
16 votes197 views2 answers
Css not last child
CSS
0 vote159 views0 answer
CSS
56 votes217 views6 answers
Center with css
CSS
0 vote196 views1 answer
Material form css
CSS