php converting string into datetime format

Question

I am having problems converting a string into datetime format in order to store variable into a datetime-type field of a sql table

value of $timestamp: 2019-02-23T08:30:03.77

$datum2 = substr($timestamp,0,19);
$datum2 = str_replace('T',' ', $datum2);
echo $datum2 ."<br>";

--> 2019-02-23 08:30:03  .... echo output looks ok to me

$datum2 = date_format($datum2,'Y-m-d H:i:s');

--> error message

Warning: date_format() expects parameter 1 to be DateTimeInterface

Thank you for any hints Stefan

Rohit Mittal · Accepted Answer · 2019-02-23 09:04:14Z

1

Check below code:

$date = '2019-02-23 08:30:03'; 
$datum2 = date('Y-m-d H:i:s', strtotime($date));

You can convert string date to timestamp and later can change to date format. Hope it helps you.

answered Feb 23, 2019 at 9:04

Rohit Mittal

2,1142 gold badges12 silver badges21 bronze badges

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

Comments

mikiqex · Accepted Answer · 2019-02-23 09:05:10Z

1

You have to use date_create function on $timestamp:

$datum2 = date_format(date_create($timestamp),'Y-m-d H:i:s');

answered Feb 23, 2019 at 9:05

mikiqex

5,3332 gold badges29 silver badges24 bronze badges

Collectives™ on Stack Overflow

php converting string into datetime format

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related