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 vote153 views1 answer
Outting a border on a map css
CSS
0 vote107 views2 answers
How to change svg image color on hover using css
CSS
0 vote124 views1 answer
Keeping text to be in one line
CSS
0 vote119 views2 answers
How to give text stroke in css
CSS
25 votes118 views4 answers
Text shadow effect
CSS
0 vote106 views1 answer
Link para inserir css
CSS
0 vote125 views1 answer
Margin-top not working
CSS
0 vote107 views1 answer
Sass immediate child
CSS
7 votes99 views3 answers
Css stop text wrapping
CSS
0 vote115 views1 answer
CSS Attribute Selector with role attribute
CSS