Level 122
What column type is event_date?
Jul 17, 2021
3
Level 4
Laravel whereBetween date filter
Hello, I have filter where using this format 2021-07-17 YYYY-MM-DD In DB I have format 2021-07-17 11:01:02 YYYY-MM-DD HH:mm:ss
Trying make filter , this works when I use full format YYYY-MM-DD HH:mm:ss, but I filter using only YYYY-MM-DD
EventLog::whereBetween('event_date', array($start_date, $end_date))->paginate(50);
Level 4
$table->string('event_date')->nullable();
Level 122
Its a string, so you cannot perform any date comparisons. Your column should be date/time or timestamp.
Please or to participate in this conversation.