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 vote323 views1 answer
Resize logo html css
CSS
2 votes306 views2 answers
Button hover disabled
CSS
0 vote365 views4 answers
Position absolute prevent overflow
CSS
4 votes302 views1 answer
How to stop an image repeating in css
CSS
1 vote336 views1 answer
Ul li seprator
CSS
4 votes365 views2 answers
Amc
CSS
0 vote337 views1 answer
Display inline-block not working
CSS
0 vote309 views1 answer
Css using border top border bottom to create a hamburger icon
CSS
1 vote355 views4 answers
Screen orientation css
CSS
3 votes321 views6 answers
Uncaught TypeError: $ is not a function
CSS