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

1 vote119 views1 answer
Css code examples
CSS
0 vote126 views2 answers
Icon rounded corners css
CSS
0 vote120 views1 answer
Css background image svg not showing
CSS
0 vote119 views1 answer
Many pseudo selectors in css
CSS
0 vote114 views1 answer
Npm registry package not found
CSS
6 votes140 views3 answers
.row bootstrap
CSS Bootstrap
2 votes116 views1 answer
Media queries css responsive max width
CSS
6 votes145 views5 answers
Font-style css
CSS
2 votes121 views1 answer
Twig ternaire
CSS
0 vote112 views1 answer
Css detect if input has value
CSS