How to convert array to string in laravel

Question

$date = gc_head::select('DATE','point_no')->orderBy('DOCDATE','desc')->limit(7)->get();

This return something like array format

[{"DATE":"2021-06-11 00:00:00","point_no":"SRT-358"},{"DATE":"2021-06-11 00:00:00","point_no":"SRT-359"},{"DATE":"2021-06-11 00:00:00","point_no":"SRT-360"},{"DATE":"2021-06-10 00:00:00","point_no":"SRT-357"},{"DATE":"2021-06-10 00:00:00","point_no":"SRT-356"},{"DATE":"2021-06-10 00:00:00","point_no":"SRT-355"},{"DATE":"2021-06-09 00:00:00","point_no":"SRT-348"}]

I want to isolate DATE and point_no. For example

$year=['2015','2016','2017','2018','2019','2020'];

I tried $date['DOCDATE'] to isolate date it's not working. Is there any better way to fix this??

Answer 1

$date = gc_head::select('DATE','point_no')->orderBy('DOCDATE','desc')->limit(7)->get();

$date_array = array();

foreach($date as $dat){
  array_push($date_array, \Carbon\Carbon::parse($dat["DATE"])->format('Y');
}

return $date_array;