Laravel whereDate and whereDay Example

In this small tutorial we will see laravel whereDate and whereDay example, as you all know laravel provide many inbuilt functionalities like query builder, eloquent etc.

So, here i will give you example of whereDay and WhereDate using date function in laravel 8.

The whereDate method is used to compare a column's value against a date. whereDate() through we can make condition like date even column datatype timestamps.

Example-1:

$birthdate = DB::table('students')
            ->whereDate('bday', '2021-01-01')
            ->get();
dd($birthdate);

 In this example you will get all result of bday which one have date like 01-01-2021.

Example-2 : 

$birthdate = DB::table('students')
            ->whereDate('bday','<=','2021-01-01')
            ->get();
dd($birthdate);

 

The whereDay method is used to compare a column's value against a specific day of the month, whereDay() through we can get only specific day records from your timestamps column.

 Example:

$birthdate = DB::table('students')
            ->whereDay('bday', '2021-01-01')
            ->get();
dd($birthdate);

In this example you will get all data which one date day value has 01.