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 vote192 views1 answer
Css transform duration
CSS
25 votes190 views5 answers
Scroll animation css
CSS
0 vote177 views1 answer
Override package css
CSS
0 vote134 views1 answer
Css flex fixed width
CSS
0 vote176 views1 answer
Css fadeIn opacity transition
CSS
8 votes190 views3 answers
Text break css
CSS
2 votes163 views2 answers
How use befor after for image
CSS
0 vote175 views1 answer
Reorder images in mobile web developer
CSS
1 vote195 views1 answer
About us page template html css codepen
CSS
0 vote179 views1 answer
Style scrollbar table
CSS