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

2 votes182 views1 answer
Media queries css responsive max width
CSS
0 vote193 views1 answer
Showing danger message in red in terminal bash
CSS
3 votes200 views3 answers
Remove box around button when clicked
CSS
2 votes225 views1 answer
Tailwind icon animation
CSS
7 votes152 views2 answers
Remove horizontal scrollbar css
CSS
1 vote173 views1 answer
Class indicator css
CSS
0 vote205 views2 answers
Woocommerce align add to cart buttons css
CSS
2 votes180 views1 answer
Mat slide toggle change color
CSS
0 vote184 views1 answer
Css psedou content data
CSS
1 vote195 views1 answer
Kommentar css
CSS