php convert european datetime to mysql datetime
Posted
by
Mathlight
on Stack Overflow
See other posts from Stack Overflow
or by Mathlight
Published on 2014-06-04T09:22:10Z
Indexed on
2014/06/04
9:24 UTC
Read the original article
Hit count: 229
I'm really stuck with this problem. I've got an datetime string like this: 28-06-14 11:01:00
I'm trying to convert it to 2014-06-28 11:01:00
so that i can insert it into the database ( with field type datetime
.
I've tryed multiple things like this:
$datumHolder = new DateTime($data['datum'], new DateTimeZone('Europe/Amsterdam'));
$datum1 = $datumHolder -> format("Y-m-d H:i:s");
$datum2 = date( 'Y-m-d', strtotime(str_replace('-', '/', $data['datum']) ) );
$datum3 = DateTime::createFromFormat( 'Y-m-d-:Hi:s', $data['datum']);
This is the output i get:
datum1: 2028-06-14 11:01:00
datum2: 1970-01-01
And i get an error for datum3
:
echo "datum3: " . $datum3->format( 'Y-m-d H:i:s'); . '<br />';
Call to a member function format() on a non-object
So my question is very clear... What am I doing wrong / how to get this working?
Thanks in advantage guys!
I know that this question is asked many, many times... But whatever i try, i can't get it working...
© Stack Overflow or respective owner