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

1 vote306 views1 answer
Text-shadow
CSS
1 vote276 views2 answers
Overflow-x hidden not working
CSS
1 vote232 views1 answer
Css image background center horizontally in div
CSS
0 vote299 views1 answer
How to debug datatables
CSS
0 vote271 views1 answer
Mettre icloud en dossier barre
CSS
20 votes304 views2 answers
Css disable selection
CSS
1 vote286 views1 answer
How to put mulitple conditions in media query
CSS
13 votes298 views4 answers
Responsive css grid
CSS
238 votes419 views5 answers
Include bootstrap
CSS Bootstrap
60 votes282 views6 answers
Center div horizontally and vertically
CSS