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

39 votes316 views5 answers
Add drop shadow css
CSS
0 vote379 views1 answer
Protéger les fichiers .htaccess et .htpasswds
CSS
9 votes342 views4 answers
Clamp css
CSS
0 vote332 views1 answer
Setting size for png icon in CSS
CSS
0 vote325 views1 answer
Fullcalendar react
CSS
1 vote320 views3 answers
Background image in css is not working
CSS
2 votes322 views1 answer
Reset a tag css
CSS
0 vote353 views1 answer
Bash access array indirectly
CSS
0 vote349 views1 answer
Alternative for lodash omit in javascript
CSS
12 votes370 views3 answers
Docker restart container
CSS