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 vote155 views1 answer
Remove required effect in css
CSS
0 vote168 views1 answer
Width calc(100 - 100px)
CSS
0 vote174 views2 answers
Ul class= social-icons
CSS
2 votes172 views4 answers
Laravel htaccess
CSS
0 vote144 views1 answer
Sdsd
CSS
2 votes200 views1 answer
Css area not selectable
CSS
1 vote123 views1 answer
Css hover darken color
CSS
0 vote178 views2 answers
How to change jumbotron size
CSS
-2 votes288 views3 answers
Box sizing reset
CSS
0 vote183 views1 answer
Input checkbox size css
CSS