PHP date format from a date format like "23 Nov, 2015 16:44:26 GMT"

Question

I am doing scraping and I got a date like 23 Nov, 2015 16:44:26 GMT. I would like to convert it to Y-m-d H:i:s so that I can save it to database datetime field.

I tried like this:

echo date("Y-m-d H:i:s", strtotime("23 Nov, 2015 16:44:26 GMT"));

I have also removed GMT by preg_replace and then

echo date("Y-m-d H:i:s", strtotime("23 Nov, 2015 16:44:26"));

It's giving 1970-01-01 01:00:00

I tried like this. **echo date("Y-m-d H:i:s", strtotime("23 Nov, 2015 16:44:26 GMT"));** I have also removed GMT by preg_replace and then **echo date("Y-m-d H:i:s", strtotime("23 Nov, 2015 16:44:26"));** It's giving "1970-01-01 01:00:00" — Azad Abul Kalam, Jan 08 '16 at 06:21

score 2 · Answer 1 · answered Jan 08 '16 at 06:07

2

You can use DateTime::createFromFormat to convert string to DateTime object. http://php.net/manual/en/datetime.createfromformat.php

answered Jan 08 '16 at 06:07

Rifky

1,444
11
26

Faiyaz Alam · Answer 2 · 2016-01-08T07:44:58.050

1

try this

<?php
$datestr = "23 Nov, 2015 16:44:26 GMT";
$datestr = str_replace(",", "", $datestr);
$dateArray = explode(" ", $datestr) ;
unset($dateArray[count($dateArray)-1]);

$newDateStr = '';
$i=0;
foreach ($dateArray as $dateArrayValue)
{

    $hyphenStr = " ";
    if($i>0 && $i != 3)
    {
       $hyphenStr = "-";  
    }

   $newDateStr .= $hyphenStr.$dateArrayValue ;
   $i++;
}
$newDateStr = trim($newDateStr);

echo date("Y-m-d H:i:s", strtotime($newDateStr));
?>

Also visit : http://php.net/manual/en/function.strtotime.php

edited Jan 08 '16 at 07:44

answered Jan 08 '16 at 06:11

Faiyaz Alam

1,191
9
27

1

Did you try this code? https://eval.in/498939 – chris85 Jan 08 '16 at 06:22
No. I have modified it. – Faiyaz Alam Jan 08 '16 at 07:45

score 1 · Accepted Answer · answered Jan 08 '16 at 10:10

You can create a DateTime using DateTime::createFromFormat.

For the 'GMT' part from your date, you can use 'T' in the format for the Timezone abbreviation.

$dateTime = DateTime::createFromFormat('d M, Y H:i:s T', '23 Nov, 2015 16:44:26 GMT');

echo $dateTime->format('Y-m-d H:i:s');

Will result in:

2015-11-23 16:44:26

Demo

PHP date format from a date format like "23 Nov, 2015 16:44:26 GMT"

3 Answers3