Better way to filter any eloquent model by date
User::whereDate('created_at', date('Y-m-d'));
User::whereDay('created_at', date('d'));
User::whereMonth('created_at', date('m'));
User::whereYear('created_at', date('Y'));
- Use
WhereDate
to filter column byY-m-d
format - Use
WhereDay
to filter column by Day (01-31) - Use
WhereMonth
to filter column by Month (01-12) - Use
WhereYear
to filter column by Year Number