[FIXED] How to select min and max in laravel

Issue

I want to convert this code in laravel.

SELECT MAX(date_start) AS DateStart,MIN(date_end) AS DateEnd FROM DBTest

And I try this code

$data = DB::table('DBTest')
    ->select(max('date_start'), min('date_end')))
    ->get();

Return Error: max(): When only one parameter is given, it must be an array

I am using laravel 5.2, and SQLyog as database

I am confuse in syntax please help me

Solution

You can't use functions in select statement, but you can use raw SQL :

$data = DB::table('DBTest')
   ->select(\DB::raw('MIN(date_start) AS DateStart, MAX(date_end) AS DateEnd'));
   ->get();

Answered By - Vincent Decaux