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 vote371 views2 answers
Electron draggable
CSS
0 vote357 views1 answer
Css remove link border on click
CSS
0 vote413 views1 answer
Screen sizes for css media
CSS
1 vote359 views1 answer
Css system default font
CSS
1 vote356 views1 answer
How to make div scrollable horizontal
CSS
127 votes364 views4 answers
React import bootstrap css
CSS
0 vote375 views1 answer
Twig data uri
CSS
1 vote329 views1 answer
Disable checkbox click event
CSS
0 vote385 views1 answer
Css padding top screen height
CSS
1 vote356 views1 answer
Load css file flask
CSS