Convert string date to timestamp in laravel

Question

I have a string 2020-09-18T07:58:03-04:00 which i want to convert into timestamp format before storing to database. anyone can help me with this?

What have you tried? What errors are you getting? We're happy to help, but you need to make an attempt to solve the issue yourself :) — Tim Lewis
– Tim Lewis, Commented Sep 22, 2020 at 16:43
use this date('d -m -Y',strtotime('2020-09-18T07:58:03-04:00')) .. — نور
– نور, Commented Sep 22, 2020 at 16:46
or use this date('Y -m -d',strtotime('2020-09-18T07:58:03-04:00')) — نور
– نور, Commented Sep 22, 2020 at 16:47
Hi, welcome to SO. Please update your question and provide a MRE (stackoverflow.com/help/minimal-reproducible-example) with relevant code parts. — avia
– avia, Commented Sep 22, 2020 at 18:08

mmabdelgawad · Accepted Answer · 2020-09-22 16:49:08Z

2

You can do

Carbon::parse('2020-09-18T07:58:03-04:00')->toDateTimeString();

// OR

Carbon::parse('2020-09-18T07:58:03-04:00')->format('Y-m-d H:i:s');

Result: 2020-09-18 07:58:03

answered Sep 22, 2020 at 16:44

mmabdelgawad

2,5452 gold badges9 silver badges16 bronze badges

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

2 Comments

Actually i want to get a timestamp like this 2020-09-22 14:59:11

2020-09-22 14:59:11 This is not timestamp check the update answer

Jernej Beg · Accepted Answer · 2020-09-22 17:24:34Z

2

This should do the trick if you want a timestamp:

Carbon::parse('2020-09-18T07:58:03-04:00')->timestamp;

But I don't think that you need a timestamp to store the date. Parsing should be enough.

$model->my_date_field = Carbon::parse('2020-09-18T07:58:03-04:00');
$model->save();

answered Sep 22, 2020 at 17:14

Jernej Beg

395 bronze badges