date range

@marsuch check this

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_str-to-date

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-sub

something like

->whereRaw('date(str_to_date(date_column_name, "%Y-%d-%m %H:%i%s")) >= date(date_sub(curdate(), interval 30 day))')

@marsuch

You could also use Carbon since is already available within Laravel. It's a wrapper for DateTime class. The code should look like this:

$date = \Carbon\Carbon::now()->subDays(30)->startOfDay();
DB::table('erp_obj')->where('created_at', '>=', $date)->get();

There is also the whereDate clause, which will take only the date part of a timestamp. So you could do something similar to what viorel proposes:

DB::table('erp_obj')->whereDate('created_at', '>=', now()->subDays(30))->get();

Thanks for the help, in the end it turned out to be too bad. I sat there for almost 15 hours yesterday. And so he didn't mean it to me anymore, I tried Carbon, of course. But they will also succeed originally. Because the error was in the prefix. When I had prefixes stored in the database in the form prefix_ and not _prefix.