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 vote182 views1 answer
How to set border length in css without div
CSS
1 vote208 views3 answers
How to stop input from highlighting onclick
CSS
104 votes257 views6 answers
Media screen
CSS
1 vote182 views1 answer
Class indicator css
CSS
0 vote205 views1 answer
Using to in linear gradient css
CSS
0 vote216 views1 answer
Child theme broken header "styles.css"
CSS
1 vote185 views3 answers
Tag php
CSS
0 vote192 views1 answer
Css get screen height
CSS
0 vote190 views2 answers
Css firefox remove scrollbar
CSS
8 votes187 views1 answer
When hover target diffrent element
CSS