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 vote383 views1 answer
Checkbox border css
CSS
0 vote352 views1 answer
CSS logo left and navigation right
CSS
-2 votes394 views1 answer
How to add pseudo class in html
CSS
0 vote535 views1 answer
Mvc how to css file linked
CSS
0 vote353 views2 answers
Text decoration underline padding
CSS
6 votes340 views1 answer
How to set option size to select in html css
CSS
0 vote383 views1 answer
Div with no content have a width/height
CSS
0 vote437 views2 answers
Css slick js load slider jump
CSS
0 vote347 views1 answer
Css clamp vs media queries
CSS
0 vote381 views1 answer
Tailwindcss tutorial
CSS