Answers for "eloquent where date format"

where date laravel

$q->whereDate('created_at', '=', date('Y-m-d'));

laravel created_at where date format

$topshiriqnoma = $connection->table('topshiriqnoma')->select('created_at')->whereBetween('created_at',
    [
        Carbon::createFromFormat('Y-m-d', $start_time)->startOfDay()->toDateTimeString(),
        Carbon::createFromFormat('Y-m-d', $end_time)->endOfDay()->toDateTimeString()
    ]
)->orderBy('created_at', 'ASC')->get()->groupBy(function ($query) {
    return Carbon::parse($query->created_at)->format('Y-m-d');
});