In this tutorial, we will see laravel whereMonth and whereYear example. whereMonth and whereYear are used to get month and year data from specific date field columns. So, here we will use whereMonth() and whereYear() in laravel 8.
The whereMonth
method is used to compare a column's value against a specific month. whereMonth() will help to get specific month records from date.
So, let's see laravel whereMonth and whereYear example, date function in laravel 8, whereMonth and whereYear in laravel 6, laravel 7 and laravel 8.
Example :
$users = DB::table('users')
->whereMonth('created_at', '12')
->get();
In this example, we will get results from the created_at column which one has month is 12.
The whereYear
method is used to compare a column's value against a specific year, whereYear() will help to get only specific year records from your timestamps fields
Example :
$users = DB::table('users')
->whereYear('created_at', '2021')
->get();
In this example, you will get data from the created_at column which contain 2021 year.
You might also like :