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

4 votes122 views1 answer
Disable input filed
CSS
0 vote160 views2 answers
How to set background image for button in css
CSS
3 votes159 views1 answer
Font family comic sans ms
CSS
0 vote145 views1 answer
How to change height font css
CSS
1 vote157 views1 answer
Alert without page refresh
CSS
2 votes198 views1 answer
Bootstrap dark mode
CSS Bootstrap
1 vote259 views2 answers
Block elements css
CSS
0 vote151 views1 answer
Remove position absolute attribute by adding css
CSS
3 votes147 views2 answers
Css transition all
CSS
0 vote151 views2 answers
Drop function postgresql
CSS