Laravel Eloquent whereDate() Query Example

Laravel 6 , Laravel , Laravel 7

Nicesnippets

1047

13-07-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...


Recommended Posts