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: 228

Filed under:
|
|

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

Related posts about php

Related posts about sql