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:
Hi,
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:
$record["DATE"]
...REPLACE that with:
date("Y-m-d H:i:s",strtotime($record["DATE"]))
Hope this helps!
Cheers,
David
--
MagicParser.com