Laravel no results returned when working with datetime field

Question

So I have this query:

Report::whereDate('date', '=', Carbon::now()->format('Y-m-d H:i'))->get();

Dates are stored like this for example:

2017-01-08 10:00:00

But I never get any results, does this have to do something with the seconds? If so, how can I avoid this and get my results? Using a mutator perhaps to ignore seconds?

PS. I want to get the results from the specified time, because I am using it for a scheduled task (command). E-mails should be sent at specified times, and the times vary :)

Answer 1

You can try with WhereRaw

$format = Carbon::now()->format('Y-m-d H:i');
Report::whereRaw("date_format(date, '%Y-%m-%d %H:%i ')  = '$format'")

Answer 2

I figured it out, I didn't want to use a boolean in my database to check wether or not an e-mail has been sent for the specific report, because they are daily reports. But I will another cron job to reset these booleans at the end of the day.

Answer 3

Add date to $dates property in the Report model:

protected $dates = ['date'];

You said you want to check the time, so just do this:

Report::where('date', Carbon::now())->get();

Answer 4

I guess I've mis understood the question.

The convenient way to match date time is by using Carbon.

In your model add the following line.

protected dates = ['date'];

By doing that your dates will be saved as Carbon instance.

Now you can do

Report::whereDate('date', Carbon::now())->get();