select models that more than 24 hours have passed since their creation in laravel

Question

I think that question title is Self-Descriptive.

In fact I want to select all rows that more than 24 have passed since their created_at attribute in laravel with Carbon and where clauses.

$question = Question::where('created_at',/* what do I here*/);

How can I do that ?

Show your code or this question is getting flagged soon. – Frondor Nov 22 '16 at 08:56 — Frondor, Nov 22 '16 at 08:56

score 4 · Accepted Answer · answered Nov 22 '16 at 09:04

4

Try this:

$question = Question::where('created_at', '>=', Carbon::now()->subDay())->get();

answered Nov 22 '16 at 09:04

Mayank Pandeyz

I updated question. I want rows that **more than 24 hours** have passed since their creation – Ahmad Badpey Nov 22 '16 at 09:32

Michel · Answer 2 · 2016-11-22T09:47:49.640

1

$question = Question::where('created_at', date("Y-m-d H:i:s",strtotime("22-11-2016"."-1 day")));

edited Nov 22 '16 at 09:47

answered Nov 22 '16 at 09:06

Michel

1

While this code snippet may solve the question, [including an explanation](//meta.stackexchange.com/questions/114762/explaining-entirely-code-based-answers) really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion. Please also try not to crowd your code with explanatory comments, this reduces the readability of both the code and the explanations! – kayess Nov 22 '16 at 11:07

score 0 · Answer 3 · answered Jul 04 '22 at 19:50

0

Question::where('created_at', '<', now()->subHours(24));

answered Jul 04 '22 at 19:50

jaxramus

3 Answers3