Convert string Y.m.d H:i:s to timestamp Y-m-d H:i:s in PHP

Question

For example I have this string "2015.02.10 01:24:13". And I need it to be converted to timestamp format 2015-02-10 01:24:13. I tried this

$dtime = DateTime::createFromFormat("Y-m-d H:i:s",$new_data['query_start_date']); 
$post->query_start_date = $dtime->getTimestamp();

But it didnt work.

timestamps don't actually have format; they're signed integers — Mark Baker, Jun 21 '16 at 07:06

Narendrasingh Sisodia · Accepted Answer · 2016-06-21T07:09:59.650

2

It didn't work

Its because you were creating a wrong format for the date i.e.

DateTime::createFromFormat("Y-m-d H:i:s",$new_data['query_start_date']);

should be

$dtime = DateTime::createFromFormat("Y.m.d H:i:s",$new_data['query_start_date']);
                                     ^^^^^// Changed the date format as you've defined i.e. 2015.02.10 01:24:13

And for formatting your date you need to use format method of DateTime class like as

$post->query_start_date = $dtime->format("Y-m-d H:i:s");

edited Jun 21 '16 at 07:09

answered Jun 21 '16 at 07:06

Narendrasingh Sisodia

21,247
6
47
54

Just to complete the answer: and then you just format it the way you want with $datetime->format('Y-m-d H:i:s') http://php.net/manual/en/datetime.format.php – lllypa Jun 21 '16 at 07:09
1

Thanks a lot! It worked. – user2622255 Jun 21 '16 at 08:30

Convert string Y.m.d H:i:s to timestamp Y-m-d H:i:s in PHP

1 Answers1