Laravel/Eloquent 5 whereBetween not working as expected

Question

I am using Laravel 5, and I would like get rows between two dates in my database (SQLite).

I am using this command:

$trackers = Tracker::whereBetween('detect_at', [$date1, $date2])->where("serial", "uhu")->get();

But I get no response.

Entire request:

$date1 = "2015-07-13 03:53:38";
$date2 = "2015-07-13 03:58:36";
$trackers = Tracker::whereBetween('detect_at', [$date1, $date2])->where("serial", "uhu")->get();

Here is an example of one row in my database:

id   serial  latitude   longitude   altitude    accuracy    detect_at                     created_at               updated_at
728  uhu    48.0491     -1.74138    0           20          2015-07-13 03:54:38           2015-07-02 13:40:15         2015-07-02 13:40:15

seems relevant: http://stackoverflow.com/questions/24824624/laravel-q-where-between-dates I think your dates need to be date-objects — endofsource, Aug 06 '15 at 20:22
What is the database column type for your `detect_at` column? Also, can you paste the SQL that is generated? — lowerends, Aug 06 '15 at 20:41

score 6 · Accepted Answer · answered Aug 07 '15 at 00:11

6

Wrap the dates in Carbon objects:

// At top of file
use Carbon\Carbon;

$trackers = Tracker
    ::whereBetween('detect_at', [new Carbon($date1), new Carbon($date2)])
    ->where("serial", "uhu")
    ->get();

answered Aug 07 '15 at 00:11

Ben Claar

3,285
18
33

3

I don't know how this answer helpfull to you, but it's not working. – Deviser Jul 20 '20 at 12:30

score 0 · Answer 2 · answered Jul 25 '21 at 23:00

0

$query->whereDate("created_at",'>=',$from)->whereDate("created_at",'<=',$today);

answered Jul 25 '21 at 23:00

Michael

46
6

1

This answer would be more useful if you described how/why it solves the problem. – Cleptus Jul 26 '21 at 06:50

Laravel/Eloquent 5 whereBetween not working as expected

2 Answers2