laravel get data up to today code example

Example 1: where('created_at', '=', date('Y-m-d'));

$q->whereDay('created_at', '=', date('d'));
$q->whereMonth('created_at', '=', date('m'));
$q->whereYear('created_at', '=', date('Y'));

Example 2: where('created_at', '=', date('Y-m-d'));

$q->where('created_at', '>=', date('Y-m-d').' 00:00:00'));

Example 3: where('created_at', '=', date('Y-m-d'));

$q->where(DB::raw("DATE(created_at) = '".date('Y-m-d')."'"));