Date & Time Formating

[stephenl7]

Hello

 

I am trying to store the date and time from a email header (retrived using imap_fetch_overview) in a MYSql database

 

My current code seems logical, however doesn't work

 

    // read datetime from header

    $datestr = $overview->date;

    // format
    $dateTime = DateTime::createFromFormat('D, d M Y H:i:s O', $datestr);

    $errors = DateTime::getLastErrors();
    if (!empty($errors['warnings'])) {
    echo "Invalid Date\n"; }

 

    // convert to mysql format   
    $date = $dateTime->format('Y-m-d H:m:s');

 

Reported error

Fatal error: Call to a member function format() on a non-object in

 

Any advise and suggestions would be appreciated

 

Thank you

 

[jcbones]

Your object creation is failing, returning a boolean false.  Make sure your date string matches your format string.

 

Right now you are telling it to create the string from a date that looks like "Mon, 01 Jan 2013 23:40:12 +0500".

 

I would suggest dumping the $datestr variable, and making sure it matches that format.

[priyankagound]

To convert a date retrieved from MySQL into the format you requested (mm/dd/yy H:M (AM/PM)), try the following;

$datetime = strtotime($row->createdate);
$mysqldate = date("m/d/y g:i A", $datetime);

 

MySQL's standard format is: date("Y-m-d H:i:s", $datetime)