
wheredate in laravel not working
wheredate in laravel not working
In this session, we’ll try our hand at solving the "wheredate in laravel not working" puzzle by using the computer language.
There could be any issue in script while comparing with column's value that's why wheredate method is not working. WhereDate method is used to compare a column's value against a date in laravel-
Laravel whereDate() method on created_at field
$users = User::whereDate('created_at', '=', date('Y-m-d'))->get(); return $users; //Or $users = User::whereDate('created_at', '=', '2021-8-31')->get(); return $users;
Output:
[{"id":16,"name":"Kayla","email":"[email protected]","email_verified_at":null,
"created_at":"2021-08-31T08:24:43.000000Z","updated_at":"2021-08-31T08:24:43.000000Z"}]This code snippet will help you to get the records from users table on the base of current (today) date. You can pass date "2021-8-31" in ('Y-M-D') format as third argument to whereDate() method to get the record of specific date from table.
-
Laravel whereDate() method on created_at field with dynamic value
//2021-08-02 $users = User::whereDate('created_at', '=', User::find(1)->created_at->toDateString())->get(); return $users; //2021-08-02 $users = User::whereDate('created_at', '=', User::find(1)->created_at->format('Y-m-d'))->get(); return $users; //Output : [{"id":16,"name":"Kayla","email":"[email protected]","email_verified_at":null,"created_at":"2021-08-02T08:24:43.000000Z","updated_at":"2021-08-31T08:24:43.000000Z"}]
You can pass dynamic value to whereDate method using created_at() and toDateString() method on create_at attribute. The method format() and toDataString() convert the timestamp (date and time) value into date format.
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- How to get list of all views file in laravel
- Add a subselect based on relationship using withAggregate method
- How to avoid duplicate entries in pivot table in Laravel
- Store logged in user details in session and display in view in laravel
- Route not defined in Laravel
- Laravel URL validation not working
- Extract only time from datetime in laravel
- How to create and run user seeder in laravel
- How to use more than one query scope in Laravel
- How to print form data in laravel
- Call to undefined relationship [user] on model [App\Models\Post]
- In order to use the Auth::routes() method, please install the laravel/ui package
- How to get specific columns using with method in laravel Eloquent relationship
- Send post data from controller to view
- Laravel delete all rows older than 30 days
- Get Array of IDs from Eloquent Collection
- Update if exist else insert new record in laravel
- How to get tomorrow and yesterday date in laravel
- How to generate .env file for laravel?
- How to change default timestamp fields name in Laravel
- How to get user information using hootlex/laravel-friendships package in laravel
- Update last created record in Laravel
- Get all users except the followings users in overtrue laravel-follow
- How to increment column value of table in Laravel
- First and last item of the array using foreach iteration in laravel blade