Laravel 9 whereDate And whereMonth Query Example

WebSolutionStuff | Oct-19-2022 | Categories : Laravel

In this article, we will see laravel 9 wheredate() and wheremonth() query examples. The whereDate method may be used to compare a column's value against a date. The whereMonth method may be used to compare a column's value against a specific month. So, we will learn wheredate() in laravel 9 and wheremonth() in laravel 9.

The whereDate() through we can make conditions like date even column datatype timestamps. The whereMonth() will help to condition for getting specific month records from date.

So, let's see a whereDate() query in laravel 9 and a whereMonth() query in laravel 9.

Syntax of the whereDate()

whereDate(Column Name, Operator, Value);

 

Example 1:

In this example, we will retrieve all records which have the date 2022-10-07.

$users = DB::table('users')
                ->whereDate('created_at', '2022-10-07')
                ->get();

 

 Example 2:

In this example, we will retrieve all those records where join_date is less than equal to 2022-10-07.

$employee = DB::table('employee')
            ->whereDate('join_date','<=','2022-10-07')
            ->get();
dd($employee);

 

Syntax of the whereMonth()

whereMonth(Column Name, Value);

 

Example 3:

In this example, we will retrieve all records which have the month 12.

$users = DB::table('users')
                ->whereMonth('created_at', '12')
                ->get();

 


You might also like:



Recommended Post


Featured Post







Follow us
facebooklogo github instagram twitter

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock or some other adblocking software which is preventing the page from fully loading.

We need money to operate the site, and almost all of it comes from our online advertising.

Please add websolutionstuff to your ad blocking whitelist or disable your adblocking software.

×