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

10 votes109 views5 answers
Media query for max width and height
CSS
0 vote112 views1 answer
Space between span and svg in css
CSS
64 votes106 views3 answers
How to use variables in css
CSS
0 vote119 views1 answer
Easyui datagrid header multiline
CSS
0 vote110 views1 answer
Divs overlapping on mobile landscape
CSS
8 votes109 views2 answers
Css border bottom
CSS
2 votes120 views4 answers
Css image sharpen
CSS
2 votes108 views1 answer
XAMPP: Another web server daemon is already running
CSS
7 votes219 views3 answers
Import font woff css
CSS
22 votes139 views4 answers
Css center in grid
CSS