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 vote256 views1 answer
Two background images css
CSS
1 vote258 views1 answer
Layer on top in javascript
CSS
1 vote235 views1 answer
Ion-content --offset-bottom
CSS
38 votes244 views6 answers
Media query min and max width for all devices
CSS
2 votes229 views2 answers
Remove bg color with css
CSS
0 vote257 views1 answer
Css input not clickable
CSS
1 vote249 views2 answers
Inline border css reactjs
CSS
2 votes226 views1 answer
Blue outline after click when in mobile view
CSS
0 vote239 views1 answer
How to use * in html
CSS
0 vote221 views1 answer
Css aufzählungszeichen entfernen
CSS