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 vote157 views1 answer
P::after p::before css
CSS
1 vote178 views1 answer
How to make border hover effect in css
CSS
8 votes165 views4 answers
Css left
CSS
0 vote169 views1 answer
How to resize img in css
CSS
0 vote190 views1 answer
How to include css in handlebars
CSS
11 votes168 views2 answers
Css line-clamp
CSS
0 vote169 views1 answer
Scss variables mixins
CSS
0 vote172 views2 answers
Wow.js
CSS
0 vote180 views1 answer
Css vertical align with flexbox
CSS
29 votes209 views1 answer
Boxsahdow
CSS