Get Unix timestamp in laravel

Question

I am storing created_at and updated_at as unix timestamp

for that i add following line to my modal its working fine.

class Test extends Model
{
    protected $dateFormat = 'U';

    protected $fillable = [
        'user_id','question_id','answer',
    ];
}

but problem is when i retrieve record its give me readable format instead of unix timestamp so how i get value as store in database i.e(1593624368). in database i use int(11) data-type for created_at and updated_at

created_at: 2020-07-01T17:45:03.000000Z,
updated_at: 2020-07-02T08:53:14.000000Z,

Does this answer your question? return unix-timestamp format for datetime formatted field in laravel — mrhn
– mrhn, Commented Jul 2, 2020 at 12:04
@mrhn may be no because i set create_at n update_at datatype as int(11) and i have many model i just put here one — Chirag
– Chirag, Commented Jul 2, 2020 at 12:10

Odin Thunder · Accepted Answer · 2020-07-02 12:32:35Z

1

U can use Laravel Date Casting

For your case:

/**
 * The attributes that should be cast.
 *
 * @var array
 */
protected $casts = [
    'created_at' => 'timestamp',
    'updated_at' => 'timestamp',
];

edited Jul 2, 2020 at 12:32

answered Jul 2, 2020 at 12:27

Odin Thunder

3,5552 gold badges33 silver badges49 bronze badges

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

2 Comments

Chirag Over a year ago

let me try this

Odin Thunder Over a year ago

check update, test in Tinker and get proper format, in my case 1581346827

Collectives™ on Stack Overflow

Get Unix timestamp in laravel

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related