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 vote202 views1 answer
Css varianbes
CSS
0 vote231 views1 answer
React right burger scrol bar
CSS
3 votes214 views1 answer
Background image css django
CSS
156 votes243 views6 answers
Center a div css
CSS
1 vote216 views1 answer
How to make border blur css
CSS
0 vote235 views1 answer
Border 1px thick
CSS
8 votes223 views2 answers
Line-weight css
CSS
0 vote221 views1 answer
Chrome remove black inline from click button
CSS
0 vote247 views1 answer
By.cssselector
CSS
16 votes224 views2 answers
Not last child css
CSS