In this tutorial, we will see how to use wheredate query in laravel. The whereDate method may be used to compare a column's value against a specifice date.
Given below are examples for wheredate query in laravel.
Example 1:
/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
$users = User::whereDate('created_at', '=', '2020-07-23')
->get();
dd($users);
}
Example 2:
/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
$users = User::whereDate('created_at', '>=', '2020-07-23')
->get();
dd($users);
}
Example 3:
/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
$users = User::whereDate('created_at', '<=', '2020-07-23')
->get();
dd($users);
}
Example 4:
/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
$users = DB::table('users')
->whereDate('created_at', '=', '2020-07-23')
->get();
dd($users);
}
I hope this example helps you.