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 vote263 views2 answers
Vim unset number
CSS
13 votes223 views2 answers
How to link a button to another page in css
CSS
0 vote281 views2 answers
Check if post page wp
CSS
0 vote190 views1 answer
Css select alternate elements
CSS
44 votes364 views5 answers
Breakpoint bootstrap
CSS Bootstrap
-1 vote276 views2 answers
Bootstrap 4 popover content from div
CSS Bootstrap
-1 vote156 views2 answers
How to add border between links in navigation bar
CSS
83 votes228 views6 answers
Css center text
CSS
0 vote195 views1 answer
How to draw rhombus in css
CSS
2 votes198 views1 answer
Css limit line text
CSS