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 vote183 views1 answer
Macbook change screenshot to jpg
CSS
0 vote153 views1 answer
Css conver innertext to html using css
CSS
0 vote152 views1 answer
CSS class inheritance
CSS
0 vote151 views1 answer
Css align backround image to the right
CSS
11 votes202 views6 answers
Transition css
CSS
0 vote152 views1 answer
Darken scss
CSS
0 vote117 views1 answer
Laravel load css from public
CSS
1 vote145 views1 answer
Comfirm before delete
CSS
0 vote175 views2 answers
Scrolling banner
CSS
-1 vote143 views1 answer
Centralize div css
CSS