return unix-timestamp format for datetime formatted field in laravel

Question

I have a Message model like this :

class Message extends Model
{
    protected $primaryKey = 'message_id';
    protected $dates      = ['created_at', 'updated_at', 'receiver_deleted_at', 'sender_deleted_at', 'sender_read_at', 'receiver_read_at'];
}

As you can see there are some date fields that hold dates as DATETIME(YYYY-MM-DD HH:MM:SS) format.

But I want when get an instance of model all date fields convert to unix-timestamp format and then return.

I know that can use accessor like this for every field :

public function getCreatedAtAttribute()
{
    dd(strtotime($this->attributes['created_at']));
    return strtotime($this->attributes['created_at']);
}

But in this case I must define a function like above for each field.

But I want an easier way that force model to return date fields as unix-timestamp format.

Accessors take care of the conversion to a Carbon instance which is an extension of default DateTime. So, $this->created_at->format('U'); should work. — Tom
– Tom, Commented Apr 22, 2017 at 11:36
@TomLank., I want when call an instance of model converted format returned — Ahmad Badpey
– Ahmad Badpey, Commented Apr 22, 2017 at 11:39

jkoop · Accepted Answer · 2021-12-16 18:25:44Z

10

protected $casts = [
    'created_at' => 'timestamp',
    'updated_at' => 'timestamp'
];

In model just add these cast to get unix timestamp

edited Dec 16, 2021 at 18:25

jkoop

1291 silver badge10 bronze badges

answered Apr 16, 2019 at 6:10

luke

2242 silver badges6 bronze badges

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

Comments

AddWeb Solution Pvt Ltd · Accepted Answer · 2017-04-22 11:45:34Z

1

You can override the :

protected function getDateFormat()
{
 return 'U';
}

OR

Use timestamp property for each column:

$model->created_at->timestamp

Reference: https://laravel.com/docs/4.2/eloquent#timestamps

answered Apr 22, 2017 at 11:45

AddWeb Solution Pvt Ltd

21.8k5 gold badges30 silver badges61 bronze badges

1 Comment

Ahmad Badpey Over a year ago

I added getDateFormat function but got this error : Trailing data

Collectives™ on Stack Overflow

return unix-timestamp format for datetime formatted field in laravel

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related