Get wrong formatted date in Laravel API

Question

I am making a API request but when i retrieve created_at then i get 2019-10-09T11:07:08.000000Z but in database it is 2019-10-09 11:07:08. How can i solve this issue? I don't want to use date formatting because i already have proper date format in my database. I just want what i have in database. Look at my database: https://prnt.sc/piljms

API Controller:

 public function singleGallery($id)
    {
        $gallery = Gallery::findOrFail($id);
        return new GalleryResource($gallery);
    }

Gallery Resource:

    return [
        'gallery_id' => $this->id,
        'created_date' => $this->created_at,
        'modified_date' => $this->updated_at
    ]

What's wrong with 2019-10-09T11:07:08.000000Z? What are you expecting? — fox91
– fox91, Commented Oct 13, 2019 at 9:15
I saw your edit, can you clarify? Do you expect a date in MySQL (or another DB) format? — fox91
– fox91, Commented Oct 13, 2019 at 9:22
I want date as it is in database stored. In database it is 2019-10-09 11:07:08 then why it is showing 2019-10-09T11:07:08.000000Z ? — Chonchol Mahmud
– Chonchol Mahmud, Commented Oct 13, 2019 at 9:24
Probably is the default settings in Laravel, you need to format the date as you need. — fox91
– fox91, Commented Oct 13, 2019 at 9:27

Avnish Tiwary · Accepted Answer · 2019-10-13 09:27:51Z

1

Using php's date and strtotime function you can format date as per your choice.

'created_date' => date('Y-m-d', strtotime($this->created_at))

I have formatted created_at in Year/month/date but you can do different formatting like d/m/Y for day/month/Year

If you would like to go Laravel way then you have to use Carbon library.

edited Oct 13, 2019 at 9:27

answered Oct 13, 2019 at 9:24

Avnish Tiwary

2,28823 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chonchol Mahmud Over a year ago

I don't want to format it like you give here. My database have 2019-10-09 11:07:08 but why it is showing 2019-10-09T11:07:08.000000Z? I just want what i have in database.

Avnish Tiwary Over a year ago

@ChoncholMahmud When you hit any query, laravel at first run its own different modules/middlewares under the hood. In this case, laravel is using the date format = 'Y-m-d\TH:i:s.u'; internally before outputting. So, you need to format in your own way.

fox91 · Accepted Answer · 2019-10-13 09:28:40Z

0

Go with this:

return [
    'gallery_id' => $this->id,
    'created_date' => $this->created_at->format('Y-m-d H:i:s'),
    'modified_date' => $this->updated_at->format('Y-m-d H:i:s'),
]

answered Oct 13, 2019 at 9:28

fox91

3821 silver badge12 bronze badges

2 Comments

Chonchol Mahmud Over a year ago

What the reason you use format() as i already have that format in my database? Take a look into my database: prnt.sc/piljms

fox91 Over a year ago

It really depends on DB tecnology, but probably your date isn't saved formatted in that way by your DB, only display it in that way. Do you read the date from your database as "string" or as PHP DateTime (or similar) object? Maybe Laravel do it for you... Can you post the result of var_dump($this->created_at);?

Chintan Hingrajia · Accepted Answer · 2022-06-15 09:06:13Z

0

<?php
    
    namespace App\Models;
    
    use Illuminate\Database\Eloquent\Factories\HasFactory;
    use Illuminate\Database\Eloquent\Model;
    use DateTimeInterface;
    
    class Notification extends Model
    {
        use HasFactory;
        
        protected $fillable = [
            'id',
            'created_at',
            'updated_at',
        ];
        
        protected function serializeDate(DateTimeInterface $date)
        {
            return $date->format('Y-m-d H:i:s');
        }
    }
    ?>

answered Jun 15, 2022 at 9:06

Chintan Hingrajia

3291 silver badge7 bronze badges

Collectives™ on Stack Overflow

Get wrong formatted date in Laravel API

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related