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 vote279 views1 answer
How to give a background color strip in html and css
CSS
2 votes335 views3 answers
How to make a html css js editor
CSS
0 vote293 views1 answer
How to move bullet in css
CSS
0 vote286 views1 answer
Image with colored background html css tigether
CSS
1 vote312 views1 answer
Css background rainbow
CSS
1 vote323 views1 answer
Css grid minmax function
CSS
0 vote301 views1 answer
Adding a perfect responsive background image
CSS
21 votes295 views2 answers
Form field focus border remove css
CSS
0 vote333 views1 answer
Translate argument animation css'
CSS
0 vote317 views1 answer
Disable text higlighting
CSS