Group by the specific day, month, and year

Admin 1
Viewed 22

I have a table as follow, now I use the group by date and it only group my data based on the year. I want to group the data based on the specific day, month, and year.

Do you know how we can do that?

enter image description here

mysql sql
1 Answers

Use:

group by  day(`date`),month(`date`),year(`date`)

Check for more info

user_164619520
Related