How to Convert Date Format in PHP

Question

how to convert Fri Jul 19 2019 00:00:00 GMT 0800 (Singapore Standard Time) this format to mysql date format using PHP? I tried to use strtotime but none of them working for me

date("Y-m-d H:i:s", strtotime("Fri Jul 19 2019 00:00:00 GMT 0800 (Singapore Standard Time)"));

The date fails to parse due to Double timezone specification (from the PHP error). — atymic
– atymic, Commented Jul 20, 2019 at 8:46

atymic · Accepted Answer · 2019-07-20 08:57:13Z

1

The date fails to parse because it's in a very weird format.

If you can't control the format of the incoming date you could grab the different parts using regex and parse them:

$rawDate = "Fri Jul 19 2019 00:00:00 GMT 0800 (Singapore Standard Time)";
preg_match('/(.*?) GMT (\d+)\s\(.*?\)/', $rawDate, $matches);

$date = DateTime::createFromFormat('D M j Y H:i:s', $matches[1])
   ->setTimezone(new DateTimeZone('+' . $matches[2]));

echo $date->format('Y-m-d H:i:s'); // outputs 2019-07-19 06:00:00

Example: https://3v4l.org/fbuMk

answered Jul 20, 2019 at 8:57

atymic

3,1481 gold badge15 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

How to Convert Date Format in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related