laravel - query date between always return empty result

Question

I am using laravel 8 and I want to get ids between two dates form created_at column which is timestamp format I use the following code

    $ids=Visit::select('id')->whereBetween('created_at',[$request->input('from_date'),$request->input('to_date')])->get();
return response($ids);

but I get an empty result

I tired to convert the inputs to time using the strtotime() function but also I get the same empty result

    $ids=Visit::select('id')->whereBetween('created_at',[strtotime($request->input('from_date')),strtotime($request->input('to_date'))])->get();
return response($ids);

the input type in view page is date

could you please help with the correct syntax

echo $request->input('from_date')." ".$request->input('to_date') print the following 2021-05-20 2021-05-21 — Mokhtar Ghaleb
– Mokhtar Ghaleb, Commented May 28, 2021 at 8:42

John Lobo · Accepted Answer · 2021-05-28 08:47:28Z

1

You can format using carbon

$fromDate=\Carbon\Carbon::createFromFormat('Y-m-d',$request->input('from_date'));

$toDate=\Carbon\Carbon::createFromFormat('Y-m-d',$request->input('to_date'));

  $ids=Visit::select('id')->whereBetween('created_at',[$fromDate,$toDate])->get();
return response($ids);

answered May 28, 2021 at 8:47

John Lobo

15.4k2 gold badges18 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

laravel - query date between always return empty result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related