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 votes155 views6 answers
Console.log with color font
CSS
1 vote156 views1 answer
Css keep background image from scrolling
CSS
0 vote149 views1 answer
How to make scroller show only on hover of container
CSS
0 vote150 views1 answer
Dynamic multi-level in vuejs
CSS
0 vote157 views1 answer
-webki slider runnable track
CSS
-1 vote200 views1 answer
Remove line breaks css
CSS
1 vote153 views1 answer
How to hover over an individual cell in table css
CSS
0 vote162 views1 answer
Css set transition duration for a property
CSS
0 vote164 views1 answer
Select tag text align center
CSS
13 votes160 views2 answers
Box-sizing
CSS