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 vote262 views1 answer
Css diminuer épaisseur trait
CSS
0 vote251 views1 answer
Css detect if input has value
CSS
0 vote301 views4 answers
Scale down image css
CSS
0 vote252 views1 answer
Symfony modify request
CSS
19 votes261 views2 answers
Center div css flex
CSS
-1 vote287 views3 answers
Clip path css
CSS
0 vote242 views1 answer
How to active horizental scroll for navbar menu in mobile screen
CSS
0 vote278 views1 answer
How to set box into another box using html and css
CSS
3 votes280 views2 answers
How to align elements horizontally in css
CSS
0 vote270 views1 answer
Css layers over background-images
CSS