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

17 votes344 views3 answers
Text orientation css
CSS
0 vote350 views1 answer
Apt list only security updates
CSS
107 votes347 views4 answers
How to add background shadow css
CSS
80 votes350 views6 answers
Css favicon
CSS
37 votes295 views5 answers
Display css
CSS
0 vote327 views1 answer
Css perspective
CSS
0 vote350 views1 answer
1 412 779 in words
CSS
0 vote369 views1 answer
Chrome extension css
CSS
3 votes317 views3 answers
Uigradients
CSS
0 vote342 views1 answer
How to mirror flip a video tag css
CSS