whereDate() and other whereX Methods

What if you have a timestamp or datetime column and want to query by date? How do you filter that? There are a few ways to use raw queries, but I will show you a few helpful methods in Laravel.

Example 1: DB::raw()

Because created_at is a datetime column, the SQL date function can be used.

User::where(\DB::raw('DATE('created_at)'), '2024-03-01')->first();

And, of course, it returns the user registered on that date.

Example 2: whereDate()

Instead of doing DB::raw() and using SQL functions, you can use the whereDate() Eloquent method.

User::whereDate('created_at', '2024-03-01')->first();

Also, instead of date, you can check...