+1 for making some effort while posting a new question
DB::select('select curdate() ');
According to laravel docs
The select method will always return an array of results. Each result within the array will be a PHP StdClass object, allowing you to access the values of the results.
DB::select('select curdate() as cur_date')->cur_date;