Why does querying date provides wrong output/result in laravel

Question

I have a uploaded_at column in database having type as timestamp.

$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.

I guess you're using the wrong date format. Try Y-m-d. Sorry, that's what Tushar already wrote below. — Joe
– Joe, Commented Mar 5, 2020 at 7:50
i tried that format in the beginning but it didn't work. i even checked if there was problem with the table using phpmyadmin by this query which gives me proper output...[ SELECT * FROM posts WHERE uploaded_at > '2020-1-1' ]... — plabon
– plabon, Commented Mar 5, 2020 at 9:12
If the column type really is TIMESTAMP, I suppose you have to use Y-m-d 00:00:00 including time information, see dev.mysql.com/doc/refman/8.0/en/… — Joe
– Joe, Commented Mar 5, 2020 at 9:45

Tushar · Accepted Answer · 2020-03-05 07:06:40Z

1

Try this code

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

edited Mar 5, 2020 at 7:06

answered Mar 5, 2020 at 6:23

Tushar

5683 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

plabon Over a year ago

i tried but still the same...to check if my database table had any problem i even checked using phpmyadmin which gave me proper results.query: [ SELECT * FROM posts WHERE uploaded_at > '2020-1-1' ]

plabon Over a year ago

i tried using your code showing 0 results. can it be because its in the localhost ...

Tushar Over a year ago

Can you check last executed query, for check the query. query is ok or not

Tushar Over a year ago

I mean can you check the query builder build which query. Is it create expected as your requirement?

Nico Haase Over a year ago

Please add some explanation to your answer by editing it, such that others can learn from it

|

STA · Accepted Answer · 2020-03-05 06:56:48Z

1

Laravel has a default package, named Carbon Which can easily handle do this, like this :

$date = Carbon::now();
$previous = $date->subMonths(2);
$data =Post::whereBetween('uploaded_at', [$previous, $date])->paginate(20);

Don't forget to use Carbon\Carbon; on th top.

Hope this helps..

edited Mar 5, 2020 at 6:56

answered Mar 5, 2020 at 6:49

STA

35.3k9 gold badges49 silver badges62 bronze badges

3 Comments

plabon Over a year ago

tried this but showing the same results as tushar's.

plabon Over a year ago

sorry there was no problem with the query....after installing xampp again it got fixed.... i think the problem was with my mysql ... thank you

plabon Over a year ago

and your answer worked for me too but i preferred tushars because it uses builtin php functions.... and whereBetween didn't work for me... This worked: $date = Carbon::now(); $previous = $date->subMonths(3); $data = Post::where('uploaded_at' , '>' , $previous)->paginate(20);

Ankur Mishra · Accepted Answer · 2020-03-05 06:23:14Z

0

Use the whereDate() function to compare date:

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

answered Mar 5, 2020 at 6:23

Ankur Mishra

1,2961 gold badge8 silver badges15 bronze badges

Collectives™ on Stack Overflow

Why does querying date provides wrong output/result in laravel

3 Answers 3

6 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related