categorize by date from timestamp

Not really sure what your question is. Do you want to insert it with that date? Or do you want to fetch it with that date?

I want to fetch the data with the date stored in my database.But this date uses timestamp.I want to categorize the data and I dont want to include the time only dates

You can format it when you output it.

{{ $something->created_at->format('m-Y-d') }}

You can also format the date in the query itself.

App\User::selectRaw("DATE_FORMAT(created_at, '%m-%Y-%d') as created_at")->find(1);

Hello @Cronix seems not working to 5.6

Show your relevant code.

Here's the code in my controller if you can see, I'm trying to get the distinct Date but I cant I dont know how to display only the dates without repeating because of the Timestamp.

$events = DB::table('soildata') ->select('SoilDataID', 'Nitrogen', 'time_stamp') ->distinct() ->get(); return view('pages.filemanager',['events'=> $events ]);

this is also my code in my view @foreach ($events as $data) {{ date('d-m-Y',strtotime($data->time_stamp)) }} @endforeach

Above codes outputs all the date and not the distinct