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

2 votes132 views1 answer
Kerning css
CSS
0 vote135 views2 answers
Css cut text of
CSS
0 vote138 views1 answer
Bulk order pre cooked pasta
CSS
1 vote128 views1 answer
How to open link in same tab in chrome
CSS
3 votes158 views2 answers
Scss transition
CSS
22 votes138 views2 answers
Css set styles for input text
CSS
18 votes129 views4 answers
Background color none
CSS
0 vote159 views1 answer
How to slow down hover effect css
CSS
2 votes121 views1 answer
Not hover css
CSS
0 vote125 views5 answers
Sweetalert to small bootstrap
CSS