check difference between created_at and today's date?

Say I want to check if created_at and today's date differ by x days how can I do this?

$latest=User::where("type","seeker")->whereNull('deleted_at')->where('created_at', '??', Date(Y-m-d))->get();

Thanks

manelgavalda

7 years ago

Level 50

You can use normal mysql operators for the comparison. For example, if you want to check if the created_at field is older than 2 days ago, you can do something like this

$latest=User::where("type","seeker")->whereNull('deleted_at')->where('created_at', '<', now()->subDays(2))->get();

1 like

realrandyallen

7 years ago

Best Answer

Level 44

Here's one way:

$latest = User::where("type", "seeker")->whereNull('deleted_at')->whereRaw("DATEDIFF(NOW(), created_at) > ?", [10])->get(); // users created > 10 days ago

Please or to participate in this conversation.