CODEWITHSUNDEEP
phplaravel
Rick
Rick

Reputation: 541

How to Convert Date Format in PHP

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)"));

Upvotes: 0

Views: 266

Answers (1)

atymic
atymic

Reputation: 3128

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

Upvotes: 1

Related Questions