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 vote300 views1 answer
Css shape-outside
CSS
0 vote339 views1 answer
Div with specific id css
CSS
0 vote309 views1 answer
If child elemnt is hovered do changes to the container css
CSS
0 vote263 views1 answer
Css logo color
CSS
1 vote301 views1 answer
Css no list markers
CSS
1 vote300 views1 answer
Before content from attribute
CSS
1 vote306 views1 answer
Css media queries pc and mobile
CSS
0 vote320 views2 answers
Woocommerce align add to cart buttons css
CSS
0 vote360 views1 answer
Css styles responsive password input eye
CSS
0 vote282 views1 answer
Css how to center images in a table cell
CSS