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

6 votes237 views2 answers
How to make all the columns equal size with flexbox
CSS
0 vote274 views1 answer
Transparent circle in a div
CSS
0 vote246 views5 answers
What is the difference between relative and absolute css
CSS
0 vote265 views1 answer
Music-metadata-browser Buffer is not defined
CSS
1 vote233 views1 answer
Css > symbol
CSS
-1 vote301 views2 answers
Insert image by css
CSS
0 vote238 views1 answer
Css hover change more than one element
CSS
0 vote216 views5 answers
Add css to javafx fxml
CSS
0 vote246 views2 answers
How to evenly space icons in a div css
CSS
0 vote258 views5 answers
Css gradient generator
CSS