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 vote146 views2 answers
Image horizontal scrolling in html
CSS
0 vote232 views1 answer
Keeping text to be in one line
CSS
-1 vote147 views1 answer
Responsiveness in bootstrap
CSS
0 vote220 views1 answer
Calendar api
CSS
4 votes189 views1 answer
Png shadow css
CSS
3 votes191 views2 answers
Scss watch command
CSS
1 vote188 views1 answer
Cursor: not-allowed is not working with pointe events none in css
CSS
55 votes198 views5 answers
Margin shorthand CSS
CSS
0 vote241 views1 answer
Card tailwind css
CSS
0 vote215 views1 answer
All heading tags selector scss
CSS