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 vote133 views1 answer
How do center using margin
CSS
0 vote132 views1 answer
Css prevent text wrap
CSS
24 votes148 views1 answer
Css gradient animations
CSS
-1 vote157 views2 answers
Trasition opacity
CSS
0 vote144 views1 answer
Webpack how to disable warning when run build
CSS
0 vote135 views1 answer
Box-shadow um ganzen div
CSS
0 vote131 views1 answer
Parcel-bundler bulma css
CSS
0 vote146 views1 answer
Justify center wont wotk with max-width css
CSS
0 vote132 views3 answers
Split large files
CSS
51 votes132 views6 answers
Ellipsis css
CSS