CODEWITHSUNDEEP
phpmysqllaraveldatetimephp-carbon
Ramzan Mahmood
Ramzan Mahmood

Reputation: 1901

Get Date time differnce base result (laravel 5.3)

I have a deliverables table and i want to get results where difference between current date time is 2 days from created date.

e.g today is 4-19-2017 i want to get all records where deadline is 4-21-2017 because here is difference of 2 days between 4-19-2017 and 4-21-2017 or also if 4-20-2017 it should also retrieve how ever if difference is more than 2 it should not be retrieve.

In short if Difference between current date and deadline is 2 days or less should be retrieve

I tried as 

$deliverables_dead = DB::table('deliverables')->where('user_id' , Auth::user()->id)->where('deadline' , '>' , Carbon\Carbon::now())->get();

its get all records where is deadline greater than current time.

Please help how can i get answer of above bold statement......

Upvotes: 0

Views: 157

Answers (1)

Alexey Mezenin
Alexey Mezenin

Reputation: 163968

Use whereBetween() and Carbon's addDays():

DB::table('deliverables')
    ->where('user_id', auth()->id())
    ->whereBetween('deadline' , [Carbon\Carbon::now(), Carbon\Carbon::now()->addDays(2)])
    ->get();

Upvotes: 2

Related Questions