CODEWITHSUNDEEP
phplaravel-5laravel-5.5
Volatil3
Volatil3

Reputation: 14978

Laravel Eloquent: How to use whereDate with Between?

I am using Laravel 5.5, I need to form a query where only date part of a datetime column should be matched, equivalent of date(date_col)='2018-01-01' kind of thing. How do I achieve this in Eloquent way? WhereDate() returns date part but is there some way to merge both?

Thanks

Upvotes: 10

Views: 51081

Answers (2)

Mehravish Temkar
Mehravish Temkar

Reputation: 4365

For merging whereDate and between you can use something like this:

User::whereBetween(DB::raw('DATE(created_at)'), array($from_date, $to_date))->get();

sql :

select * from `users` where DATE(created_at) between '2018-02-01' and '2018-02-06'

Upvotes: 29

user320487
user320487

Reputation:

You can use Carbon:

$q->whereDate('date_col', '=', Carbon::parse($date)->toDateString());

whereDate should work too, pass in the value as the 2nd parameter 

->whereDate('date_col', '2018-02-06')

Upvotes: 0

Related Questions