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 vote194 views1 answer
Animacion de gota css
CSS
55 votes192 views4 answers
Hover effects css
CSS
0 vote216 views1 answer
Css animation 3d effect
CSS
3 votes240 views2 answers
Bootstrap.min.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
CSS Bootstrap
19 votes163 views3 answers
Bootstrap media queries
CSS Bootstrap
4 votes188 views3 answers
How to not underline links in css
CSS
20 votes177 views6 answers
Fonts for css
CSS
1 vote203 views1 answer
Insert background image css error
CSS
1 vote198 views1 answer
Css 100% -20px
CSS
-1 vote189 views2 answers
How to use before pseudo class in css
CSS