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 vote130 views1 answer
Css selector not contain
CSS
1 vote144 views1 answer
Change angular material icon color
CSS
1 vote149 views1 answer
Image on top of image css
CSS
0 vote149 views1 answer
Pill shape css
CSS
16 votes180 views1 answer
Css text vertical direction
CSS
0 vote144 views1 answer
Body{text-align: center;}
CSS
18 votes208 views2 answers
Rgba blue colo
CSS
0 vote248 views1 answer
Width cross browser
CSS
0 vote151 views1 answer
Css orange color
CSS
0 vote137 views1 answer
Include css typo3
CSS