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

3 votes291 views1 answer
Css display block ease in
CSS
29 votes285 views4 answers
@font-face css
CSS
25 votes292 views5 answers
Image blur css
CSS
0 vote292 views1 answer
Rotate box-shadow
CSS
1 vote292 views1 answer
Bootstrap card hover effect
CSS
0 vote284 views1 answer
How to get 2 words one left aligh and right align in css
CSS
-1 vote288 views2 answers
Make all images same size bootstrap
CSS
0 vote286 views1 answer
Object-position
CSS
0 vote283 views1 answer
Device-pixel-ratio css
CSS
3 votes302 views1 answer
Include screen size
CSS