query where Date_format() issue

do your query as normal and set the format on your output:

$model = YourModel::all();

$formattedDate = \Carbon\Carbon::parse($model->created_at)->format('Y m d');//any format you watn

I actually want to try to get data using where like

 ->where('customer_id',$customer_id)
                ->whereRaw('DATE_FORMAT(created_at, "%Y-%m-%d %H:%i") >='.$fromDate)
                ->whereRaw('DATE_FORMAT(created_at, "%Y-%m-%d %H:%i")'.$toDate);
        }

But it keeps on saying syntx error and return 400.

your two where statements seem like they wouldn't work well together anyway - one or the other it seems. Here is one anyway which should help in doing the other

 ->where('customer_id',$customer_id)
		->whereRaw(" DATE_FORMAT(created_at,'%Y-%m-%d %H:%i') >= ? ", [$fromDate]);
        }

or maybe this...

 ->where('customer_id',$customer_id)
		->where(\DB::raw("(DATE_FORMAT(created_at,'%Y-%m-%d %H:%i'))"), ">=", $fromDate);
        }