Laravel query has wrong output

Laravel provide me the wrong output for date field query. I have a uploaded_at column in database having type as timestamp. This is my query-

$from = date("d-m-Y", strtotime("-2 months"));
$data = Post::where('uploaded_at' , '>'  $from)->paginate(20);

This piece of code is giving all the data from the post table where I needed only the last 2 months post.

Level 70

@ipibk Is your code executing properly? I noticed that there is a typo.

It should be like that

$data = Post::where('uploaded_at' , '>',  $from)->paginate(20);

instead of

$data = Post::where('uploaded_at' , '>'  $from)->paginate(20);

You forget to add , (comma).

6 likes

Level 1

Sorry. It's a typo. But still having the same issu.

4 likes

Best Answer

Level 70

@ipibk Have you tried this way?

$from = date("Y-m-d", strtotime("-2 months"));

$data = Post::whereDate('uploaded_at' , '>=' , $from)->paginate(20);

6 likes

Level 75

Use a carbon helper now()

$posts = Post::where('uploaded_at' , '>=', now()->subMonths(2)->toDateTimeString())->paginate(20);

Docs: https://carbon.nesbot.com/docs/#api-addsub

3 likes

Please or to participate in this conversation.