When I run your online demo on an XML file it shows the date field as
18 May 2013 15:27:25
But when I go to insert it into mysql it goes to
Is there a way to make it change the timestamp so it will match the SQL one?
It looks like MySQL isn't recognising it as a valid DATETIME field, but i've just checked and it converts fine using PHP's strtotime() function, so that in conjunction with the date() function can be used to convert it into a suitable value to be inserted. To do this, where you are currently using, for example:
...REPLACE that with:
Hope this helps!