Laravel - How to get column created_at without hours

Question

I want to list a couple of records and I just want to show y-m-d of created_at , not hours.

I'm doing this in query:

$letter = Letter::select('letters.id', DB::raw('DATE(letters.created_at) created_at'), 'letters.userId')
                    ->where('letters.active', '=', 1)
                    ->where('letters.userId', '=', $user->id)
                    ->paginate(20);

But returns me this column like this 2017-08-30 00:00:00

How can I solve that?

Thank you

Answer 1

Make query like this to format date in laravel

 ->select(DB::raw('DATE_FORMAT("letters.created_at, "%Y-%m-%d") as new_date', 'letters.id', 'letters.userId')

Answer 2

Cast it to Carbon/DateTime object and format it