CODEWITHSUNDEEP
phplaravel
Abdallah Sakre
Abdallah Sakre

Reputation: 915

How to get the data between two Dates and times in Laravel

I'm trying to get the data between two datetime (e.g. between 9 and 10). How can this be done in Laravel:

$sel_ans1 = Answer::where('user_id','!=', $u_id)
  ->whereBetween('created_at', '2019-09-04 09:00:00', '2019-09-04 10:00:00')
                    ->first();

Upvotes: 0

Views: 114

Answers (2)

Dino Numić
Dino Numić

Reputation: 1452

whereBetween from and to should be in array like following

  ->whereBetween('created_at', ['2019-09-04 09:00:00', '2019-09-04 10:00:00'])

Upvotes: 3

party-ring
party-ring

Reputation: 1871

->whereBetween('created_at', '2019-09-04 09:00:00', '2019-09-04 10:00:00')

should be

->whereBetween('created_at', ['2019-09-04 09:00:00', '2019-09-04 10:00:00'])

Upvotes: 3

Related Questions