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

4 votes201 views1 answer
Css selector every child except last
CSS
0 vote242 views1 answer
Css beutify scroller
CSS
5 votes196 views1 answer
Bootstrap darkmode
CSS Bootstrap
0 vote202 views1 answer
Css variables css tricks
CSS
0 vote175 views1 answer
Module not found: Can't resolve './musicas/Bruno Mars JustTheWayYouAre.mp3' in 'C:\UkVibes\react_juary\client\src\components\genders'
CSS
0 vote210 views1 answer
Css animation top goes back to start
CSS
0 vote230 views1 answer
Css border image repeat property
CSS
158 votes219 views5 answers
Css background image with url
CSS
0 vote220 views1 answer
Css loading spinner with text
CSS
7 votes266 views3 answers
Css filter color
CSS