Change format date when retrieve it from sql

Question

When I Retrieve date from SQL database in my laptop only it back to me like (May 17 2016 12:00:00:AM) but any server or another laptop back like (2016-05-17), it appears when I call date column from database and I think this issue not from code I think in PHP or apache2 in my laptop.

This is my code:

$user_data = User::with('employee')
    ->where('id', Auth::user()->id)
    ->get()
    ->first()
    ->toArray();

dd($user_data['employee']['hire_date']);

edit your question, adding your code, i.e the sql statement which fetches the date column — Bonzay, Jul 17 '19 at 13:18
You are able to format date at either MySQL level or PHP level. First, in general, will be faster. Which way would you like to go? — Tarasovych, Jul 17 '19 at 13:20
It would be far more efficient for you to do just `->first()` instead of `->get()->first()` — Rwd, Jul 17 '19 at 15:25

score 0 · Answer 1 · answered Jul 17 '19 at 13:42

0

The reason this is occuring is likely to be because on your laptop you have a DATETIME field in the database and on the server you have a DATE field. These field types are fundamentally different.

answered Jul 17 '19 at 13:42

bgld

31
5

Majid Alaeinia · Answer 2 · 2019-07-17T16:38:38.340

0

The best way is to use mutators in laravel, and also using the Carbon package.

It should be implemented like this:

Employee.php

use Carbon\Carbon;

class Employee extends Model {

public function setHireDateAttribute($value)
{
    $carbonDate = Carbon::create($value)
    $this->attributes['hire_date']->toDateString();
}

}

edited Jul 17 '19 at 16:38

answered Jul 17 '19 at 13:44

Majid Alaeinia

962
2
11
27

1

This should be in the `Employee` model rather than the `User` model. – Rwd Jul 17 '19 at 15:26
@RossWilson That's right, I edited my answer. – Majid Alaeinia Jul 17 '19 at 16:38

Change format date when retrieve it from sql

2 Answers2