Laravel Eloquent: How to use whereDate with Between?

Question

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

Mehravish Temkar · Accepted Answer · 2018-02-07 06:56:49Z

29

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'

answered Feb 7, 2018 at 6:56

Mehravish Temkar

4,3653 gold badges30 silver badges47 bronze badges

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

1 Comment

Syamlal Over a year ago

this is the right answer for whereBetween

score 0 · Accepted Answer · 2018-02-07 06:47:14Z

0

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')

edited Feb 7, 2018 at 6:47

answered Feb 7, 2018 at 6:40

user320487

1 Comment

Volatil3 Over a year ago

That was not my original question.

Collectives™ on Stack Overflow

Laravel Eloquent: How to use whereDate with Between?

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related