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 vote297 views1 answer
Style scroll react csss
CSS
2 votes300 views1 answer
Input type file placeholder
CSS
1 vote314 views1 answer
Create a animation name in css
CSS
1 vote275 views2 answers
Css focus border radius
CSS
0 vote264 views1 answer
Sass file
CSS
0 vote272 views1 answer
Best os for programming
CSS
4 votes296 views2 answers
Can we use material ui and tailwind css together
CSS
0 vote305 views1 answer
Bulk order pre cooked pasta
CSS
2 votes289 views2 answers
Remove border iframe
CSS
34 votes279 views3 answers
Css blur background image only
CSS