Video Version of the Lesson
[Only for premium members]
Courses
Laravel 12 Eloquent: Expert Level
whereDate() and other whereX Methods
You're reading a FREE PREVIEW of a PREMIUM
course.
Summary of this lesson:
- Using whereDate() and related date query methods- Understanding different date filtering approaches
- Working with DB::raw() for date queries
- Best practices for column-specific where clauses
Link to the repository
[Only for premium members]
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...
The full lesson is only for Premium Members.
Want to access all 38 video+text lessons of this course?
(1 h 34 min)
You also get:
- 84 courses
- Premium tutorials
- Access to repositories
- Private Discord