Level 104
What have you tried?
User::selectRaw('DATE_FORMAT(created_at, "%Y-%m-%d"), count(*) as count')
->groupByRaw(DATE_FORMAT(created_at, "%Y-%m-%d"))
->get();
Dec 9, 2022
1
Level 3
Group by date
How can I group by date and count users? I want someone like this based on created_at
2022-12-09 : 15
2022-12-10 : 18
Please or to participate in this conversation.