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 vote280 views1 answer
Bootstrap 5 carosul height set
CSS Bootstrap
3 votes244 views3 answers
Website gradient
CSS
1 vote247 views2 answers
Fit image in grid css
CSS
2 votes273 views1 answer
How to remove bullets from li
CSS
2 votes238 views1 answer
Css disable dropdown on input
CSS
1 vote248 views1 answer
Get second child div css
CSS
0 vote266 views1 answer
Hover media query
CSS
1 vote235 views2 answers
How to filter css red
CSS
0 vote242 views1 answer
Background effect css
CSS
0 vote266 views1 answer
CSS menu list with underline hover animation
CSS