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
How To Create Stacked Bar Chart In Laravel 9 Using Highcharts
How To Create Stacked Bar Char...

In this article, we will see how to create a dynamic stacked bar chart in laravel 9 using highchart. Here, we will...

Read More

Dec-30-2022

Laravel 8 PDF Generate Example
Laravel 8 PDF Generate Example

In this article, we will see a laravel 8 pdf generate example. For generating PDF file we will use the laravel-dompdf pa...

Read More

Oct-17-2020

Crop Image Before Upload Using Croppie Plugin
Crop Image Before Upload Using...

In this article, we will see how to crop images before uploading using the croppie plugin. any times we have requir...

Read More

Aug-15-2020

How To Integrate Email Template Builder In Laravel
How To Integrate Email Templat...

In this article, we will see how to integrate an email template builder in laravel. Also, you can integrate an emai...

Read More

Feb-22-2023