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

-1 vote363 views2 answers
Css clip-path
CSS
4 votes349 views1 answer
Overflow dottet
CSS
0 vote374 views1 answer
Css start animation on hover
CSS
3 votes354 views2 answers
Css element with id and class
CSS
16 votes436 views5 answers
Sass loops
CSS
7 votes470 views2 answers
Stick footer to bottom
CSS
4 votes404 views4 answers
Composer rollback to v1
CSS
0 vote329 views1 answer
Css opacity from 0 to 1
CSS
0 vote359 views1 answer
Media query not working with rem
CSS
0 vote342 views1 answer
Html.css.js
CSS