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 Integrate Swagger In laravel 10
How To Integrate Swagger In la...

In the dynamic realm of modern web development, ensuring that APIs are well-documented, easy to comprehend, and seamless...

Read More

Aug-18-2023

The Best Laravel Tips & Tricks for Migrations
The Best Laravel Tips & Tricks...

Migrations are an essential part of any Laravel project, allowing developers to easily manage and update their database...

Read More

Oct-23-2023

Create Dummy Data Using Laravel Tinker
Create Dummy Data Using Larave...

In this example we can see how to add multiple dummy records in the database at a time using tinker and factory, mo...

Read More

May-21-2020

Image Upload in Summernote Editor Using Laravel
Image Upload in Summernote Edi...

In this post we will see how to upload image in summernote editor. there are many editor available in laravel...

Read More

Jul-09-2021