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 vote189 views1 answer
Alternative for lodash omit in javascript
CSS
0 vote199 views1 answer
Html click through image
CSS
1 vote215 views1 answer
Ion-content --offset-bottom
CSS
-1 vote301 views1 answer
Remove line breaks css
CSS
2 votes237 views4 answers
Laravel htaccess
CSS
1 vote189 views1 answer
Bootstrap 4 material icon vertical align
CSS
1 vote188 views1 answer
Restful url to update status
CSS
0 vote179 views1 answer
Css different rules on different devices
CSS
0 vote198 views1 answer
Buttons have strange style iOS
CSS
1 vote187 views1 answer
::-ms-clear
CSS