Laravel Eloquent whereDate() Query Example

Jul 13, 2020

Hi Guys,

In this example,I will learn you how to use wheredate query in laravel.you can easy and simply use wheredate query in laravel.

The whereDate method may be used to compare a column's value against a specifice date.you can see bellow example how it is work.

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);

    
}

It will help you...